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.