It's little bit tricky to handle this type of dynamic table calculations.
But here is one idea.
Don't use "Filter " because it breaks percentage calc, se "HIDE" instead.
Changing filter does not impact to the structure of percentage calc.
HollywoodSample_SM_18.1.twbx 22.4 KB
Hi Melissa, you could do this with a Fixed Formula.
I created a parameter called Other Threshhold %.
I then created a calculation to find the % of Records for your table which uses the FIXED formula to get total sum of records as the denominator. The calculation simply says: IF % of Records < Other Threshhold % parameter, then return "Other" else return the "Genre" name.
Because we are using the FIXED formula, you will need to add the Lead Studio filter to Context in order for that filter to be taken into account by the calculation.
To do this, click the right arrow on the Lead Studio pill in the Filters pane, and click Add to Context.
I've attached the workbook. I hope this helps.
HollywoodSample.twbx 31.2 KB
Thank you so very much for your detailed explanation. I was able to recreate. I truly appreciate it!
Thank you so much!