Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I'd like to know how to calculate accumated data (e.g. total yearly sum amount) in a pivot table.
Which function should I use?
And plus, if the data doesn't reach till the end of the year, accumulated yearly sum amount is not allowed to show in the table.
Looking forward to your help.
Thank you!!
Can't you just add the Year dimension to the table to show the sum/count ect. of the data? Then just put
if(Year=Year(today()), 0 , sum(field))