8 Replies Latest reply: Nov 1, 2011 10:17 AM by Dmitry Gudkov RSS

    Subtotals for a calculated dimension?

    Dmitry Gudkov

      Spent a few days and couldn't find a solution -- your help is much appreciated.

       

      Data fields: Type, Product, Qty

       

      PIVOT TABLE

      Dimensions:

      =Type

      =if(aggr(sum(Qty),Product,Type)>500, '>500','<500')    /* labelled as Group

      Expressions:

      =Sum(Qty)

       

      Calculated dimension is grouping for Products with Sum(Qty)>500 and <500.

       

      Question: How to get subtotals for the calculated dimension to calculate percentage ?

       

      This is the table I have:

      Untitled.png

       

      This is the table I need to get:

      Capture.PNG

       

      Problem is not that so trivial as it seems -- try to play with the application (attached).

       

      Thanks!