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.