2 Replies Latest reply on Jan 16, 2016 10:48 PM by Alexander Mou

    LOD Calculation Filtering a Dimension without using Filter Card

    Chris Pham

      How do you use a LOD calculation and filter to a specific dimension without putting it in the filter card?


      In the example workbook,

           1. the Sum of Sales is $819,911 (see Fixed tab)

           2. Washington makes up $38,930 of the total Sum of Sales. (see Total Sales and Per State)

           3. Fixed LOD Calculation with WA Filter in Filter Card = $38,930 (see LOD Calculation with WA Filter)


      My question, how do we get to this $38,930 by hard coding a WA filter in the LOD calculation and not putting it in the Filter Card? Ben Neville