5 Replies Latest reply on Jul 19, 2018 1:15 AM by kumar bharat

    Top N Analysis basis more than one parameter

    Ruchika Bhandari

      Hi Everyone,

       

      I am trying to prepare top 10 customers contributing to sales vs remaining customers of a selected distributor (i.e. parameter)

       

      What I did is firstly I created a set on Customers Field and selected 'Top' tab and then By Field 'Top' 10 by 'Sales Amount' 'Sum'. This is calculating Sales Amount for Top 10 Customers and other customers for the selected reporting period.

      However, when I added a parameter to select a distributor, it is not showing the top 10 customers of the selected distributor rather it is showing sales amount of the top 10 customers calculated in the first step and its sales amount.

       

      I am trying to do build the below analysis :-

       

       

      Can anyone help me to solve this issue?