Expression against Partial Sum

[#1]

Hi all, just hoping someone can suggest if there is a way of displaying an expression referencing a Partial Sum row but showing the expression on the same row, in my very basic example I want to show the percentage of Sum of Section B divided by the number of say closed Calls (Section A) but I want it to show on the same row as the Partial Sum Total of Section B.

Also this has to be in a Pivot table as users want to see Company across the top along with potentially other dimensions like Month etc..., e,g.

Many thanks!

[sunny_talwar · Accepted solution]

This may be

=If(Section = 'B' and Dimensionality() = 1, Num(Sum(Measure)/Only({<Description = {'Total Complaints Closed'}>} TOTAL <Company> Measure), '##.##%'), Sum(Measure))

[#3]

That's a nice solution, works perfectly, many thanks!!!