Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be like:
Sum( {<Dept, Sub_Dept, CalendarYear = {$(=max({1}CalendarYear))},CalendarMonthYear=,CalendarMonth=, CalendarMonthNum = {"=$(vMaxMonth)"},CurrentMonthYear=,
Segment_Product_Level={$(=vSegmentLevel)},Level3={'Revenue'} >}REVENUE )
May be like:
Sum( {<Dept, Sub_Dept, CalendarYear = {$(=max({1}CalendarYear))},CalendarMonthYear=,CalendarMonth=, CalendarMonthNum = {"=$(vMaxMonth)"},CurrentMonthYear=,
Segment_Product_Level={$(=vSegmentLevel)},Level3={'Revenue'} >}REVENUE )
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!!