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