Hi I have a qliview app that calculates total costs and margins in a pivot table.
All of the rows calculate correctly but the total percentage doesn't weight based on the row values so I end up with
| Budget Net Sales | Budget Margin | Budget Margin % |
| 74,250 | 25,719 | 34.50% |
| 35,750 | 12,437 | 34.79% |
| 38,500 | 13,282 | 34.50% |
The total margin should not be 34.50% butu should be 25,719/74,250 ie 34.63%
The total mode is set to expression total, if I set to sum of rows I get just that the sum of rows and not the correct percentage, is there another setting somewhere I am missing?
Thanks
Matt
