Thank you for the solution but I can not use multiple measures because am doing other calculations / slice and Dice in my dashboard also showing data periodically.
Just a thought can we handle this in SQL?
Category 2 meets three different criteria.
To group those, using tableau or SQL, you need to duplicate data at least three times.
What I am saying is you cannot group each "Category+Sub Category" line item to specific group.
caclulations_SM_10.5.v2.twbx 20.4 KB
Is their any other solution? I am currently doing UNION ALL at query level, but in this case my data size got expanded also query execution time is also increased.
can we use nested case when/if else..
like I mentioned above I have multiple scenarios where I need to divide data based on some conditions and these conditions are depend upon multiple columns.
any idea or thought on above will be really helpful.Shinichiro Murakami