Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If i select the multiple month i want to show the label for all selected month.
Eg:
I select the month jan, feb ,march mean i want to show that three month are selected in expression label
Try this as well.
=IF(getfiledselectioncount(Month_field) = 0, Maxstring(Month), Concate(GetFieldSelections(Month_field),'|'))
IT is also show same think only
It is working fine but it show the month id only.
and i want two think bro
1.max(year) also
2.selected month sales
=num(Sum({$<Year={$(=Max(Year))},MonthID={$(=Max(MonthID))}>}[Total Cost]),0.00)
this is my current sales expression
=If(GetFieldSelections(Month_field),GetFieldSelections(Month_field),Max(Year) & Max(Month_field))
=If(GetFieldSelections(Month_field),GetFieldSelections(Month_field),Max(Year) &'-' & MaxString(Month_field))
=IF(getfiledselectioncount(Month_field) = 0, Max(Year) & '-' & Maxstring(Month), Concate(GetFieldSelections(Year) & '- ' & MaxString(GetfieldSelection(Month)),'|'))
Don't just blindly copy paste the expression. read the expression and modify a lil to fir your needs.