Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I've set up a pivot table based on ageing of transactions, which works great. But the subtotals and total rows don't show the correct amounts from the rows below. It seems that the total rows are not actually adding up the figures that are being calculated at line level, but rather trying to apply the line-level formula logic themselves.
I've attached a screen shot.
Thanks
Paul
What is your expression used here? Does it include some kind of if statement? I think if you add Sum(Aggr()) around your expression, you should be able to resolve your issues
Sum(Aggr(YourCurrentExpression, YourChartDimensions))