Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
G'day
I am having a sales table which shows the sales, MarginAmount and %MarginAmount which is calculated
My Sales are calculated in the table and if I am using "Total Mode" as Sum of rows I am getting the correct Total result If I am using "Expression Total" The Total in inacurate.
My problem is when I am calculating the %MarginAmount I am getting the wrong % because it uses the Expression Total.
I have also tried column(2)/column(1) but with no help
Thanks in advance
Hi
Any ratio expression is non-additive, so the sum of rows and expression calculations will differ. The total is not inaccurate, just different, and it might not be what you want.
I assume that you are using a pivot table, where you cannot select the sum of rows option. To get the sum of rows, use an expression like the following:
Sum(Aggr(.... your expression here ..., ... chart dimensions here)),
Hope that helps
Jonathan