Dynamic Label pivot / table

[joeybirdsx]

Hi

Hi team

i wish to add a Dynamic Label to a pivot / table 

i currently have

='Daily Report Table'&' :'&ProductionArea

what i wish is... if no ProductionArea filter is selected ...it just says 'All'

please help team

[Kushal_Chawda · Accepted solution]

@joeybirdsx  try below

='Daily Report Table'&' :'&if(getselectedcount(ProductionArea)>0,
getfieldselections(ProductionArea,','),'ALL')

[joeybirdsx]

Hi

Thank you , worked amazingly !!!