This content has been marked as final. Show 3 replies
As you can see in Pivot Table screenshot, the last expression((Sum(A)/Sum(B))*100) is giving me 66.666 which is calculated as (75/50)*100 accordingly to the expression when I checked the 'Show Partial Sum' option in Presentation tab of Chart properties, but I expect it to be as 125(i.e, 75+50) like it happens for Sum(A)(i.e,300+100=400) and Sum(B)(i.e.,400+200=600) expressions.
Please help me to solve this.
Note:I would be more happy if the solution can be provided at UI level instead of Script level.