Here I have attached the actual data file and pivot table, I have taken out sensitive data.

The pivot table is on tab "WO Pivot - Austin" and the desired output is on tab "Final Outcome"

Thanks

Hi James,

Thanks for sharing your file. It helps a lot.

Select a cell in your vales area, say D5 > right-click > show values as > % of row Total.

Is that what you're after?

Mynda

Hi Mynda,

Thanks for the reply!

Actually no, I want to keep the values as they are shown, as per my example on "Final Outcome", I want to sum all the 3 values under 12am to 6am 259, 249 and 294 and on row 5, and then divide by the total 2792 on P3 to get the percentage of tickets for that time period.

I don't know if this is possible within a pivot table, but thought I would throw it out there.

Thanks 

Hi James,

Thanks for clarifying. You need to add these groupings to your source data, then you can add 2 'count of DLWO#' to your values area and set one as Show Values As % of Row Total.

See example attached.

Mynda

Hi Mynda,

Thanks for your attachment. I did not think about adding a time group column heading with an if formula to each row, but this did the trick.

I adjusted your end result on your attachment and it gives me what I want.

Thanks again Mynda, you truly know you excel!!

You're welcome! I'm glad that's what you were after.