Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
May I ask for help to show the cumulative sum in a pivot table. I tried the related threads but could not get any answer, so posting a new one.
Problem
I have a table which shows value for some items across the year.
I need to create a pivot table where I need to show 2 columns only
I tried using SumRange for the YTD, but could not crack it. I don't want to show the full table, but to do the calculation in the formula and show the final YTD value.
Like this
Please help.
Hi,
You can share qvw
Hi
Can you share mock data, try like below
Expression as YTD Cumulative:
rangesum(above(column(1)),sum(Sales))
or
RangeSum(Above(total sum(Sales), 0, RowNo(TOTAL)))
also check this,
Thanks,Deva
Hi,
Please find attached the dummy data.
Thank you Devarasu. Attached is the file.
Hi,
if it's working fine. can you close this thread by marking correct or helpful. tks
I suggest using The Crosstable Load to transform your data and then use set analysis here...
Check the attached
Try with combination of the RangeSum on pivot table.