3 Replies Latest reply: Jul 3, 2009 6:27 PM by N G RSS

    Set Analysis using TOTAL to get 'mix' column to work

    N G



      Just moved to 8.5 and now using the wonders of set analysis, but cannot get it to do something an old 'if' statement would. I am just trying to get the 'mix' column to work i.e. from previous column what percentage is sales of 'total' sales'

      Month Sales Mix

      Jan 100 10%

      Feb 300 30%

      Mar 600 60%

      Used to use this...




      /SUM(total(if (YEAR=ThisYear, SALES)))

      where Sales was calculated in the column before


      Now with sets...




      / SUM(total ({$<YEAR={$(ThisYear)}>} SALES) )


      but this doesn't work :-(


      Any ideas gratefully received !