This content has been marked as final.
Show 3 replies

1. Re: Need help finding a calculation to dynamically group a dimension
Shinichiro Murakami Jul 25, 2017 6:05 PM (in response to Joe Geglio)Hi Joe
Table calculation is always tricky, but here is my approach.
To conslidate "others" into one value, change the formula as below.
dynamically change dimension name.
When sorted, keep "Other" to the bottom.
Filter only one dimension on "Others"
Set Table calculations
Change filters to "Context" for LOD to work after diltering.
Thanks,
Shin

GSS_SM_10.1.twbx 1.3 MB

GSS_SM_10.1.twbx 1.3 MB


2. Re: Need help finding a calculation to dynamically group a dimension
Joe Geglio Jul 26, 2017 8:51 AM (in response to Shinichiro Murakami)Shin,
Thank you so much, I never would have come up with this on my own!
Best,
Joe

3. Re: Need help finding a calculation to dynamically group a dimension
Shinichiro Murakami Jul 26, 2017 10:33 AM (in response to Joe Geglio)Joe,
You are very welcome.
Shin