0 Replies Latest reply on Sep 14, 2012 3:45 AM by Chris Fisher

    WINDOW AVG OF TABLE CA:C

    Chris Fisher

      I have a set of data that relates to item sales over time by store.

       

      In a table (Below) I have a "% of total" column that breaks down by pane as I flow through a product heirarchy.

       

      I have managed to create the avg "Sales_Value" column called TEST (copy), using a WINDOW_AVG calc.

       

      My problem is that I can't do the same for the first column which is a table calc already. I have tried to apply a window_avg again but all I get is 20% for all rows.

       

      Any thoughts from the geniuses out there?

       

      Capture.PNG