
1. Re: Aggregate and NonAggregate Mix Calculation
Joe Oppelt May 16, 2018 2:18 PM (in response to Milton Forde)If there is any aggregate in the calc, it has to end up being a measure.
And if any one token in there is an aggregate, the EVERY reference to a fiend has to be an aggregate (if the field itself is not already an aggregate.)
Is [Dollars per Eq Vol] an aggregate? If not, then you have to aggregate it with SUM or MIN or ATTR, etc.
And maybe wrapping all those [SubCategory] = "POD" iterations on one ATTR() envelope works, but I would be doing ATTR([SubCategory]) = "POD" individually on each one.

2. Re: Aggregate and NonAggregate Mix Calculation
Dan Cory May 16, 2018 3:29 PM (in response to Joe Oppelt)What exactly are you trying to compute? [Dollars per Eq Vol] is an aggregate that computes SUM([Dollars]) and SUM([Eq Vol]). But you want that summed over which records? All of them? Just one MKT, PER, or SubCategory?
You may need to use a level of detail expression to tell Tableau how to compute [Dollars per Eq Vol] but it will depend on what you want.
Dan

3. Re: Aggregate and NonAggregate Mix Calculation
Milton Forde May 17, 2018 10:44 AM (in response to Dan Cory)Hi Dan!
Thank you for responding. I would want my calculations to be summed over all records, so the user can then filter on a MKT, PER, etc to get at the breaks I'm trying to create.
Milt

4. Re: Aggregate and NonAggregate Mix Calculation
Dan Cory May 17, 2018 12:57 PM (in response to Milton Forde)1 of 1 people found this helpfulIf you aggregate all records, there will only be one number and so only one of your "segments" will apply. Is that what you are expecting?
Dan

5. Re: Aggregate and NonAggregate Mix Calculation
Milton Forde May 17, 2018 1:26 PM (in response to Dan Cory)I got it!
I reviewed what both you and Joe said, and it was a simple fix. I needed to remove the Sum from my calculation. In essence I did not need the calculation summed, which was causing my issue. Once I removed it, I was able to get my break outs and the Null went away.
Thank you for the feedback as it helped me to figure this out.
Thanks again!
Milt

6. Re: Aggregate and NonAggregate Mix Calculation
Joe Oppelt May 17, 2018 1:29 PM (in response to Milton Forde)1 of 1 people found this helpfulI just opened up your workbook, and while I was looking at it you posted this.
Yes. If you want that calc to be done for each row, then yank the SUMs out of it.

7. Re: Aggregate and NonAggregate Mix Calculation
Milton Forde May 17, 2018 1:34 PM (in response to Joe Oppelt)Thanks again Joe.
I appreciate the inputs!!
Milt

8. Re: Aggregate and NonAggregate Mix Calculation
Joe Oppelt May 17, 2018 1:38 PM (in response to Milton Forde)I marked your own reply as "correct answer" to close out this thread.

9. Re: Aggregate and NonAggregate Mix Calculation
Milton Forde May 17, 2018 1:42 PM (in response to Joe Oppelt)Thank you.