2 Replies Latest reply: Oct 27, 2011 6:12 PM by Hector Ponce RSS

    using dimension's field on expressions of set_analysis

      with set_analisys i realized a simple table with one dimension "Month" and two expressions:

      Year Sales: sum ($ {} <Year= {$(=Only(Year) )}> Sales)

      Year Sales-1: sum ($ {<Year= {$(=Only(Year) -1} )}> Sales)

      gives the following result:

      | Month | Year Sales | Sales Year-1
      | Jan     | 10             | 5
      | Feb     | 8              | 11

      and so on ...



      If I now add the dimension "Year", I no longer have the result I expected: divides the values in the respective years (rightly )..... and I do not know how to get out ....

      Year | Month | Year Sales | Sales Year-1
      2010 | Jan |                   0 |         5
      2010 | Feb |                  0 |        11
      2011 | Jan |                 10 |          0
      2011 | Feb |                  8 |          0

      thanks in advance to those who want to help me!