I want to create a new dimension 'Dimension city' where %sales <20 then make it other else keep the original name.
I want to input this percentage criteria from a parameter.
So if I increase the input criteria to 30% then Cardiff would be overwritten to Other.
The ultimate goal is to make a pie chart out of this new 'dimension city'.
Below are the steps I followed to get the expected result.
4) On editing the value in parameter filed, we can able to get the expected result.
Thanks for answering, can you please attach the file.
Attached already as part of my earlier reply.