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

    Shahidah Jefferies

      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
      MadisonMontpelier350033025    3,167 $277.91 1.001.001.131.061.051.018$1,126,869
      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

              

      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
      MadisonMontpelier350033025    3,167 $277.91 1.001.001.131.061.051.018$25,462,383
      MonroeAsh Lawn350035010  70,026 $277.91 1.001.001.131.061.051.018$25,462,383
      JeffersonMonticello410031050    1,874 $262.64 1.001.001.091.061.051.018$608,688
      TOTAL $30,903,061