7 Replies Latest reply: May 27, 2014 6:36 AM by sasi k RSS

    Using identifiers and modifiers


      Hi,

       

      I am working with a sales report and I would need to show not only period and YTD figures but also full year figures.

       

      What kind of set analysis I would need to write to be able to show full year figures? I would need to somehow be able to ignore period selection but include the year selection.

       

      so below is simple example

       

       

      PeriodValue

      1

      10
      210

      3

      10
      410
      510
      610
      710
      810
      910
      1010
      1110
      1210

       

      So let's assume now it is period 5. My report should show periodic value 10, YTD value 50 and full year figure 120. How can I get that 120? it doesn't work with identifier full set 1, because then I would ignore all selections done and I would get data from previous years also. How to write: I want sum of seleceted year and ignore month selection?

       

       

      Thanks

       

      Regards

      Janne