I have one pivot table i need to do the cumulative sum for nly few rows. and i ve few filters as well in dashboard. the filters should be affecting the pivot table... pls look the attached file to get a clear view. can u pls help me out with this.
You could cumulate in pivot-tables with expressions like this : rangesum(sum(%), above(total sum(%), 1, rowno(total))) - have a look on the attachment. But this won't work with your mixed structure from absolutely and relatively values. Generally I would suggest to separate this in two columns.
