set analysis

[#1]

HI,

in my dashboard  year and month listboxes are there.

when i clicked any year and month then appear  sales of that year,above all months of that selected month

EX:

i selected 2014,march output is sales of mar,apr,may........dec in 2014

i selected 2013,march output is sales of mar,apr,may........dec in 2013

[sushil353 · Accepted solution]

Hi,

Try like:

Sum({<Year= {'$(=Max(Year))'},Month = {">= $(=Max(Month))"}>}Sales)

HTH

Sushil

[kiranmanoharrode]

Hi Anil,

Try Below Expression:

=Sum({<DateField={"$(>=Max(DateField))"},YearField=,MonthField=>}Sales)

Regards,
Kiran

[jagan]

Hi,

Try like this, If you have a date field

sum({<MonthDimension=, DateDimensionName={'>=$(Date(Max(DateDimensionName)))<=$(=YearEnd(Max(DateDimensionName)))'}>}Sales)

Hope this helps you.

Regards,

Jagan.