-
1. Re: Mixing Aggregate and Non Aggregate with Dynamic Measures and DImensions
Joe OppeltNov 26, 2018 2:18 PM (in response to David Matthews)
I assume you are talking about [Choose Primary Measure].
Notice how that goes onto the SIZE shelf as SUM([Choose Primary Measure] ?
That's why you can't mix aggs and non-aggs. If you had an aggregate in the calc, then the SUM() would be aggregating an aggregate.
In that calc, change all the measures to SUM([Sales]), SUM([Quantity], etc. Then they will also be aggs, and you can add your aggregate calc. Take the current pill off SIZE, and re insert it after your change to the calc. You will see that now it's AGG([Choose ...]) and you'll be all set.
-
2. Re: Mixing Aggregate and Non Aggregate with Dynamic Measures and DImensions
Jim DehnerNov 26, 2018 2:21 PM (in response to David Matthews)
Hi DAve
you can create aggregate versions of all the measures
and then use this
where each measure agg is now like this
your tree will look like this
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
-
3. Re: Mixing Aggregate and Non Aggregate with Dynamic Measures and DImensions
Aaron Sheldon Nov 26, 2018 8:31 PM (in response to David Matthews)The canonical use for mixing values with aggregates is in generating standard scores, by subtracting the estimate of the mean, and then dividing by the estimate of the standard deviation. Universally, any mixing of aggregates with non-aggregates is accomplished by wrapping the aggregate in an empty INCLUDE level of detail calculation, which will automatically calculate over the dimensions selected on the worksheet. Thus given a measure [X], the standard score is given by the calculation.
[Z] := ([X] - { INCLUDE : AVG([X]) }) / { INCLUDE : STDEV([X]) }