
1. Re: Calculated Field that References a Particular Dimension Value
Ken Flerlage Jun 7, 2018 1:40 PM (in response to Jonathan Whiting)I'm not sure I understand what you're trying to do exactly. Are you saying that the denominator of the calculated field is based on Model and the numerator is based on Site?

2. Re: Calculated Field that References a Particular Dimension Value
Michel Caissie Jun 7, 2018 1:50 PM (in response to Jonathan Whiting)Jonathan,
Assuming you have a single row for each Model  Site
you can go with
flow / {FIXED [Model]: SUM( if [Site] ="Site A" then Flow end)}
the denominator means;
for every group of Model, if the Site is A return the Flow.
Now you have to aggregate this , and the aggregation choice depends on your dataset.
If you have a single row per Model  Site, you could use anything.
If you have multiple rows with site A, you may want to SUM the Flow.
And if you have multiple rows with site A, and the Flow is duplicated then you need MIN,MAX or AVG.
Michel

3. Re: Calculated Field that References a Particular Dimension Value
Jonathan Whiting Jun 7, 2018 1:54 PM (in response to Ken Flerlage)Ken, I bolded values to make things more clear. The denominator is always the value for Site A within the same Model.

4. Re: Calculated Field that References a Particular Dimension Value
Jonathan Whiting Jun 7, 2018 2:02 PM (in response to Michel Caissie)Thanks Michel, I didn't even think to add an if statement within the level of detail expression... very clever!
I have a single row per Model  Site, so I'll play around with an aggregator that works for the view.