Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a radar chart showing two groups - our organisation and the sector. The sector group can be divided into three categories and what I want to do is show on the chart label which group is being selected. I can do this with an if statement but the issue I'm having is that I have the sector data as an alternate state and I can't get the IF statement to work for the alternate state. Here is my statement:
=if([Inst/Inst Group]='Benchmark','Benchmark', if([Inst/Inst Group]='Competitor','UCAS competitor',if([Inst/Inst Group]='Other','Sector')))
Where do I put the alternate state in the syntax?
Thanks
Alison
Try this:
pick(match(only({State1}[Inst/Inst Group]), 'Benchmark', 'Competitor', 'Other'), 'Benchmark', 'UCAS competitor', 'Sector')
Hope this helps!
Try this:
pick(match(only({State1}[Inst/Inst Group]), 'Benchmark', 'Competitor', 'Other'), 'Benchmark', 'UCAS competitor', 'Sector')
Hope this helps!
That's great - thank you!
Alison