Showing results for 
Search instead for 
Did you mean: 

How to make a Total in a pivot as a RSUM from the all the history until the point of time

9 - Travel Pro
9 - Travel Pro

Hi all,

We are facing a requirement about the Grand Total calculation in a Pivot table. The scenario is the following:

W ehave a row with the YTDSUM of a metric, and a filter of time.It works as expected. But in the total of this column, we need the SUM of all the accumulated history, not just the SUM of the column. Do you know how to solve it?


Voice of Customer
Impact Business Intelligence (BI) and Analytics Market Research

Click Here & Complete Dresner's Wisdom of Crowds® Market Study Survey Today!

Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Need additional support?:

Community Support Request

Don't miss out:

Earn a BETA Launch Challenge Badge!