1 Reply Latest reply on Nov 16, 2016 11:29 AM by Toby Erkson

    Fixed LOD - But needs to recalc When Filtered

    Crystal Wilcox

      Hey Everyone,

      I've attached a workbook where I want to compare actual Sales Data by Month to the Average for each Month (all Januarys, Febs, March, etc.)

      I created a Fixed Lod to create the average          {Fixed [Month]: Avg([Net Sales])}


      which is exactly what I want, but it doesn't change when I filter. .


      I've tried everything I can think of Window calc; table calc; putting all the variables that I'll need to filter on -  in the Fixed LOD


      {Fixed [Month],[Global Entity Division], [Global End Market]: Avg([Net Sales])} .  Can't get it to work.



      Thanks for all your ideas!