4 Replies Latest reply on Apr 5, 2018 6:57 PM by Deepak Rai Branched from an earlier discussion.

# Re: Issue with aggregation of data and LOD calc

Hi Everyone, I'm using Tableau 10.2 and the proposed solution is not working for me, does anyone have any recommendations.  This is the result I'm looking for where

NamePlace Use CdSub CdSizeFactor 1Factor 2Factor 3Factor 4Factor 5Factor 6Factor 7Calculated formula
WashingtonMt Vernon340034010    6,837 \$534.45 1.001.001.131.061.051.018\$4,678,364
MonroeAsh Lawn350035010  70,026 \$277.91 1.001.001.131.061.051.018\$24,916,376
JeffersonMonticello410031050    1,874 \$262.64 1.001.001.091.061.051.018\$607,855
TOTAL \$31,329,465

Calculated formula = Size*Factor 1*Factor 2*Factor 3*Factor 4*Factor 5* Factor 6*Factor 7

However, when I apply this LOD formula, the Madison row "Calculated formula" is not captured because it is not  the "MAX" value.  How do I capture all of the values not just MAX.  I need Sub Cd LOD for Size and Use Cd LOD for Calculated Formula.
SUM({FIXED [Name],[Place],[Use Code],[Sub Code]:MAX([Calculated formula)])})
Results from LOD formula above

 Name Place Use Cd Sub Cd Size Factor 1 Factor 2 Factor 3 Factor 4 Factor 5 Factor 6 Factor 7 Calculated formula Washington Mt Vernon 3400 34010 6,837 \$534.45 1.00 1.00 1.13 1.06 1.05 1.018 \$4,678,364 Madison Montpelier 3500 33025 3,167 \$277.91 1.00 1.00 1.13 1.06 1.05 1.018 \$25,462,383 Monroe Ash Lawn 3500 35010 70,026 \$277.91 1.00 1.00 1.13 1.06 1.05 1.018 \$25,462,383 Jefferson Monticello 4100 31050 1,874 \$262.64 1.00 1.00 1.09 1.06 1.05 1.018 \$608,688 TOTAL \$30,903,061
• ###### 1. Re: Issue with aggregation of data and LOD calc

Here It is:

If it Helps, Pl mark it Helpful and CORRECT to close Thread.

Thanks

Deepak

• ###### 2. Re: Issue with aggregation of data and LOD calc

Thanks Deepak, but for some reason this solution does not work with blended data sources, where dimensions "Use Cd" and "Sub Cd" are in the secondary data source and all other dimensions are in the primary data source and measure "Size" is in the secondary data source, "Calculated Formula" is a calculated field, and all other measures are in the primary data source.

• ###### 3. Re: Issue with aggregation of data and LOD calc

i created a calulation 1 in your workbook. use it.

• ###### 4. Re: Issue with aggregation of data and LOD calc

Attached