Please post .twbx file.
Hi Tushar More
Thanks for offering to help!
Unfortunately I can't send packaged workbook due to data protection controls on my company pc (all web posts are blocked). But this seems like a simple(ish) problem. If writing the solution in plain English, I want to say -
When selecting Stock in the Parameter, bring back all rows in the data table where account status=new or account status=existing.
When selecting Stock in the Parameter, filter/exclude all rows in the data table where account status=closed.
Any wisdom you can offer would be greatly appreciated.
1 of 1 people found this helpful
Tushar More, you are a genius! Thanks so much for your help!!
This method works perfectly for my labels - it needed a few small tweaks as my data is slightly more complicated than I explained above but that was simple enough after following your instructions.
I'm now trying to get this to work for the Sunburst chart I've created with this data. I'm optimistic that I'll be able to figure it out on my own but hope you don't mind if I get back in touch if I get stuck again.
You are welcome.