Month trend with SET

[#1]

Hi,

I have the following set syntax and I use it for every month * 12

sum({ $<Month = {'Apr'}>} [Sales])

The problem I have is if i select Mars I would like to have 0 in the April and all the month ahead but have values in Jan til Mars columns

How could i solve that ?

Regards mikael

[#2]

Hi Mikael, check this attached doc. is that what you're looking for....

[#3]

Hi,

How could I use the syntax toghter with my different month columns ?

Regards mikael (-;

[#4]

Hi mikael: check the attached doc....its a workaround.

[#5]

Hi,

It works as I wanted but I see a problem in the layout.

I will have columns on the month I select - for exampel I select April I then will have the following columns

Jan, Feb, Mars and April (works fine) but I then need to have YTD this year and YTD last year.

How could I solve that ?

I think I must create seperat month columns and then have a statement that I will not show any value in the columns above the one I select.

exemple.

If I select month Feb I will have values on Jan and Feb and 0 on all the rest month colums.

Regards mikael