Compare sales

[thewillemzelluf]

Hy everyone,

I have a question. I have a mastercalender and i want to compare sales (this year Vs. Previous year). I have a YTD (this and previous year) but I dont want to compare sales from januari until now but from march until now. How can i do that? (Without just using the filter pane).

[Lisa_P]

Hi Willem,

Set analysis would be the best solution.  You could limit based on quarter or month, not sure of your field names, but something like this ..

     Sum({$<CYTD={1}, Month={">3"}>}Sales) for this year

     Sum({$<LYTD={1}, Month={">3"}>}Sales) for last year

as your expressions for each measure

[thewillemzelluf]

Thankyou Lisa! thats the solution