5 Replies Latest reply: Sep 21, 2011 12:27 AM by Angus Monro RSS

    Problem using the set analysis



      I have a bar chart showing the total sales for each year (X-dimension = Years, Y-dimension = Total amount of sales). In the raw data set/database, i have the total amount of sales for each quarter. Fyi, one year is divided into 4 quarters. If i would like to show the total amount of sales for the last two quarters only of each year, how should i accomplish it using the set analysis? Why the below set expression does not work?


      sum( {$<QUARTER={$(=Max(QUARTER)), $(=Max(QUARTER))-1}>}  AMOUNT)


      Thanks much in advance for your help!