0 Replies Latest reply: Mar 18, 2012 1:31 AM by qliktree RSS

    using aggr with an if statement



      I'm trying to create a subtotal uisng an if statement


      Sample Data


      Total 6,458
      Product 102,000
      Product 212,592
      Product 321,866


      Solution required

      Product 102,00031%
      Products 1 to 24,45869%
      For Selected Dimensions6,458100%


      So, I need to add Products 1 to 2 toghether and express it as a % of the totlal of each dimension a user selects.


      Thanks in advance.