1 Reply Latest reply on Mar 31, 2016 3:34 AM by Manideep Bhattacharyya

    Drill down view filtering based on summation values in the view

    Eshwar Prasad

      Hi team,


      i have requirement like below.


      i have column (% of total sales) in the Text table.

      i need to filter this text table based the sum of % of total sales column.


      i will have a filter with values 5%, 10% etc.


      if i select 5% in the filet will be filtered based the sum(% of total sales) =5%.


      i tried in the below.

      % of Total sales = RUNNING_SUM( SUM([Sales]) / TOTAL(SUM([Sales])) )


      Customers in 5% = ROUND( [% of Total sales] )=5. But it is not giving any result.

      PFA for your reference.