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.

       

      https://public.tableau.com/profile/c.wilcox#!/vizhome/5yearsaverage/Sheet5

      Thanks for all your ideas!