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

    using aggr with an if statement

      Hi,

       

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

       

      Sample Data

       

      ProductsRejectedCount
      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.

       

      Brian