7 Replies Latest reply on Oct 15, 2016 4:09 AM by Rohit Kumar

    How to show % of total on Top N parameter

    Rohit Kumar

      Hi all,

      I am facing a issue when i filtering "category" wise "customer name" sales  using "Top N parameter" , i added Rank function, through Rank function i used one calculated filter to filter Parameter value. Till this i am very clear and i am getting correct values but i want category  wise % of total aggregation. when using parameter either product filter i want total of % is 100.

       

      If i use index, it's filtering over data n showing top customer name wise top values only (ex: if i filter Top 5, it's  taking 2 values from one category and 3 values from  another category) , but i want every category wise customer name  sales only. here working % of total is fine.

      Please do the needful.

       

      Actual requirement  is  "Category wise Top N  sales with % of total should be 100% after filtering the data".

       

      See my requirement in attached worksheet.