I would like to generate a report of this kind. In which I will select a month from the dashboard prompt and the respective graph should display Top 1% of the customers who contributed for highest amount of sales and vice versa for the rest.
In %Spend in Pivot Table, i should get (27850590/387213414)*100 but it is taking the individual amounts, can you please give me the solution for that
what is the column formula forĀ %spend?