My users have a hand built report showing tickets by time frame and their priorities.
Priority Count 1 68 2 41 3 61 N/a 24 % of Priority 1 35%
The final row of their table is just the percentage of tickets that were a #1 for that week
=A2/SUM(A2:A5) and it displays a rolling 52 weeks of data so a wide, ugly and useless report but I'm not in a position to influence that, only to improve the speed of delivery.
In my reworking of the report, I chose to use PowerPivot as it simplifies the data refresh scenario for us. I pulled the data back and everything looks good but I can't for the life of me figure out how to have it compute the above as a "grand total" row. If it's possible, what's the formula/expression/DAX thing I need to look at?
I know I can do the calculation "outside" of the pivot table but if they add a new priority or something of that nature, I think the refresh will bleed into the cell.