When using Period Comparison in a Pivot Table, the Column total is summing the period specified in Period Comparison and the current period. In a Data Table, the Column total is only totaling the values for the period specified in Period Comparison.
Hi @hannah.paxton,
Thank you for raising this issue!
May I confirm that you’re referring to this Column total in Pivot Table?
In a Data Table, the Column total is only totaling the values for the period specified in Period Comparison.
I assume you are referring to the Row total (or Sum row) in Data Table, yes?
If so, we weren’t able to reproduce the issue from our side at the moment. The Sum row still calculates for both the current period, and the comparison period.
Can you help share a screenshot of the issue, if you still encounter it?
P.s: I’d be happy to create a support ticket to follow up, if the data is sensitive.
Hello! Apologies that wasn’t quite clear - I was referring to the the column totals indicated by the red annotated box on the Pivot Table & Data Table respectively. The data is sensitive, but I’d be happy to provide links in a support ticket!
Thank you for replying, Hannah.
Yes, let me create a support ticket to better follow up.