Hello, I have the pivot table using the sample Business Review dataset.
I have a Total column on the right and a Total row at the bottom.
I want the Totals on the right to be the sum of the row, and the Totals at the bottom to be the sum of the column.
Right now, the Totals at the bottom are not the sum of each column.
For example, I want the Total under Dec 2016 to be (7714.27 + 4846.89 + 3916.68) = 16477.84, Total under Nov 2016 to be (-1123.68 + 501.86 + -287.32) = -909.14, and so on.
How can I do this?
CalcField is coalesce(periodOverPeriodDifference(max({Billed Amount}), Date), max({Billed Amount})).
Thanks!