I am trying to get the percentage per month based on the Running Total in Excel Pivot Table.
My Pivot Table consists of the following: Report Date (Grouped by Month) Days to report (grouped by > 24 Hours and < 24 Hours) Value (count of incidents with "Show value as" Running Total in Report Date)
I got my desired counts but I am having difficulty finding a way to calculate % Total By Row. I attached a picture of my Pivot and the desired outcome that I'd like. I like that for each month, I can see the % of greater than and less against the total for that month "Grand Total"
How do I do this?