0 Replies Latest reply on Aug 28, 2013 10:36 AM by Julius

    Dynamically creating a measure

    Julius

      Synopsis:

      I have a table with an amount column and within the same column an aggregate has been mixed. This agg can be SUM, AVG, or WEIGHTED AVG or whatever. This is typical in spreadsheets. As long as the agg row is qualified (name-value pair) it can be transposed as a separate measure. I did this in order to be able to do row-level calcs against the agg as well as having the convenience of having the measure on its own axis for charting.

       

      I want to get the community's critique on this method of dynamically creating a measure. I want to see if this is the optimal way.

      Workbook: How to: Dynamic Measure Axis