7 Replies Latest reply on Jun 13, 2018 5:39 AM by Harold Orel

    Fixed LOD Calc at a specific element in a dimension

    Harold Orel

      Hello Data Rock Stars,

       

      I want to create a Fixed LOD expression for just the "East" region. 

       

      {fixed [Region]= "East" : sum([sales])} does not give the desired result.

       

      This calc shows the Sales for the East Region, but for other Regions if gives the Total Sales Minus the East Region.  I want the LOD to show the Sales just for the East Region even when the other Region are displayed on the Row shelf.

       

      Thank you.

       

      Harold...