Hello,

In my Pivot Table, I have a column of Sales members, a column of WO types, and a column of 0s and 1s indicating errors in work orders. The sales members are in the row labels, the WO types are in the Column Labels, and in the values, I want to display the percent of errors by Total number of WOs. Using the value settings only gives me % of category totals, not the whole total. I created a calculated field that is (Errors/788). 788 is the number of rows that contain reliable data (another calculated field in the data set which is in the report filter field of the pivot table). I don't want to use the hardcoded 788. It's a simple sum of Reliable_data. I've added a single cell with that calculation into my raw data, but I can't figure out how to use it in the calculated field.

I've tried using indirect() but that's not allowed. I've tried using sum(reliable_data), but that gives the sum for just the cross section of each Sales member and WO type. Maybe a formula is the wrong way to go about this and there's a built in feature?

Thanks