Hi all,
I need to count the total number of Materials and then get the accumulative % of each of the total, while ranking it by the value field "Sell Through".
e.g.
There are 100 Materials in total, hence, 1 Material accounts for 1% of the total. The first 5 (ranked by Sell Through) account for 5%, the first 10 account for 10% of the total etc...
I am currently using a helper column to do that (column A) but want to do it within the pivot as the data keeps changing/expanding. Is that feasible somehow?
fdsfdsfdsfds.PNG
Bookmarks