Help on Set analaysis Month Condition

[#1]

HI Everyone,

I am trying to create a set analysis condition .

I need Sum FCTotal 1 where the FcMonthsid and  Year-Month Number Matches. 

sum({$<[FC Month Sid]={"$(=[Year-Month Number])"}>}[FcTotal1])

When i refresh the dashboard for one month the formula gives the result. When i refresh the dashboard for multiple months it is not giving any value.Please help me on achiving this.Thanks in Advance

[vikasmahajan]

USE THIS EXPRESSION  BY DEFAULT THIS WILL SHOW YTD AND WHEN U SELECT MONTH THEN MONHTS ALSO

SUM({$<FiscalYear={$(=max(FiscalYear))}>} [FcTotal1] )

vikas

[#3]

Hi Krishnan,

I'd say this is working as intended for now. This set analysis will only work if you have oneYear-Month selected otherwise how does it know what value of [FC Month Sid] to compare it to. If you want it to work for multiple month selections you need to decide what it's function will be.

i.e. do you want it to sum up where [FC Month Sid] = the maximum value of Year-Month possible  or do you want it to sum up where [FC Month Sid] <= the max value or Year-Month?

Andy

for the first option to work you will need:

=Sum({$<[FC Month Sid]  = {"=$(=Max([Year-Month Number]))"}>}[FcTotal1])

and for the second

=Sum({$<[FC Month Sid]  = {"<=$(=Max([Year-Month Number]))"}>}[FcTotal1])

When no selections are made in Year-Month it will default to the max value in your data set.