Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I have condition in Pivot expression
SubstringCount(Concat(Qtr, '|'), 'Q1)'
and List box for Qtr (StateA) , so If I select Q1 than particular column display otherwise not.
How do I apply StateA (Alternate State) in above Substring command line
Thanks
Try this:
SubstringCount(Concat({StateA}Qtr, '|'), 'Q1')
Add a closing single quote after Q1: SubstringCount(Concat({StateA}Qtr, '|'), 'Q1')
Or try: max({StateA}match(Qtr,'Q1'))
Good catch
Works, Thanks guys
Works, Thanks guys
No problem