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.