
1. Re: "Rollup" data and recalculate result
Joe Oppelt Aug 13, 2018 12:58 PM (in response to Christopher Ray){ FIXED [Measure] : SUM([Numerator]) }
this will sum up the numerators for each measure value (assuming [Measure] is a dimension.)
Same for Denominator.
The results of this can be treated as a dimension if you want. 
2. Re: "Rollup" data and recalculate result
Christopher Ray Aug 13, 2018 1:33 PM (in response to Joe Oppelt)Hi Joe Oppelt,
I'm not quite getting it. So, ultimately, I want my "Result" field to be dynamic with filters. It should always follow this general formula but should recalculate based on the currently filtered data: SUM(Numerator)/SUM(Denominator)*Multiplier
I tried
{ FIXED [Measure] : SUM([Numerator])/SUM([Denominator[)} *[Multiplier]
But it's only calculating the result on the full dataset, and is not dynamic with the filters I use.

3. Re: "Rollup" data and recalculate result
Joe Oppelt Aug 13, 2018 1:44 PM (in response to Christopher Ray)1 of 1 people found this helpfulMake two FIXED calcs. One for numerator. One for denominator. It looks like the [Multiplier] is constant along a given measure, so you could probably just do MIN or AVG for that one, and not need the LOD.
{ FIXED [Measure] : SUM([Numerator]) }
{ FIXED [Measure] : SUM([Denominator]) }
I'm suggesting, therefore, that your final calc would look something like this:
[Numerator LOD calc]/[Denominator LOD calc] * MIN([Multiplier])
Yes, regarding filters, usually they don't impact FIXED calcs. Tableau's order of operation evaluates the FIXED LODs before filtering. But order of operation shoves "in context" filters before doing FIXED LODs. So right click on whatever filter(s) you want to impact these LODs, and select "Add to context".

4. Re: "Rollup" data and recalculate result
Joe Oppelt Aug 13, 2018 1:45 PM (in response to Joe Oppelt)BTW, you can nest LODs with others in one calc.
{ FIXED [Measure] : SUM([Numerator]) } / { FIXED [Measure] : SUM([Numerator]) } * MIN([Multiplier]

5. Re: "Rollup" data and recalculate result
Christopher Ray Aug 15, 2018 7:36 AM (in response to Joe Oppelt)Hi Joe Oppelt,
Thanks again for the help. I have a followup question for you. I'm doing something similar on another worksheet, but now I have an added "cut" of the data. Now the desired output looks something like this:
I have an added dimension in the columns to segment the data into the three "hubs". Each hub has their own numerator and denominator and calculated result. I now have date as a filter as well. The "Result" calculated field is still as follows:
{FIXED [Measure]: SUM([Line Monthly Member Measure Numerator])/sum([Line Monthly Member Measure Denominator])}*[Multiplier]
It is returning different results per individual measure (as expected), but the same result across each of the hubs. When changing { FIXED [Measure] to { FIXED [Hub Final], it does change the values, but still not the desired result (still the same value for each hub).

6. Re: "Rollup" data and recalculate result
Joe Oppelt Aug 15, 2018 7:40 AM (in response to Christopher Ray)1 of 1 people found this helpfulYou probably want to do
{ FIXED [Measure],[Hub Final] : ...
And you mentioned a date filter. By Tableau's Order Of Operations, FIXED calcs get evaluated before filters do. But if you want the filters to impact the FIXED calcs, right click on the filter and select "Add to Context". This moves the filter before the FIXED calcs in the order of operations.

7. Re: "Rollup" data and recalculate result
Christopher Ray Aug 15, 2018 7:57 AM (in response to Joe Oppelt)Thank you Joe Oppelt !!! This is working for all my sheets but one. On this one sheet, it's returning an asterisk for some results *.
What does an * indicate?

8. Re: "Rollup" data and recalculate result
Joe Oppelt Aug 15, 2018 8:00 AM (in response to Christopher Ray)1 of 1 people found this helpfulYou have different values per [Measure] in that cell. Probably different [Hub Final]s have different values. Drag [Hub Final] behind the [Measures] pill on the columns shelf and see if there are different values.