Set analysis help

[saumyashah90]

Hi I have a Straight Table chart in my  UI with some filters on my side

i have   month,year,Sub_Dept , Dept,Team and FA

In chart i m showing expression

Sum( {<CalendarYear = {$(=max({1}CalendarYear))},CalendarMonthYear=,CalendarMonth=, CalendarMonthNum = {"=$(vMaxMonth)"},CurrentMonthYear=,

Segment_Product_Level={$(=vSegmentLevel)},Level3={'Revenue'} >}REVENUE

No i have three filters,

1)Dept

2)Sub Dept

3)FA

i want these expression to get change when FA is selected but not when dept and Sub Dept is selected.

[tresesco · Accepted solution]

May be like:

Sum( {<Dept, Sub_Dept, CalendarYear = {$(=max({1}CalendarYear))},CalendarMonthYear=,CalendarMonth=, CalendarMonthNum = {"=$(vMaxMonth)"},CurrentMonthYear=,

Segment_Product_Level={$(=vSegmentLevel)},Level3={'Revenue'} >}REVENUE )

[Anonymous]

Try this just modifying ur expression:

Sum( {<Dept=, Sub Dept=, CalendarYear = {$(=max({1}CalendarYear))},CalendarMonthYear=,CalendarMonth=, CalendarMonthNum = {"=$(vMaxMonth)"},CurrentMonthYear=,

Segment_Product_Level={$(=vSegmentLevel)},Level3={'Revenue'} >}REVENUE

Hope this will help!!