See the attached -
first pivot the 2 columns that include the values shown below'
then create a set of the values in the Pivot Field Values you want to see
then add this to group the Other
you can do what ever with the data now - in a text chart it looks like this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Waterfall (1)_v2018.2.twbx 73.0 KB
This is a mock version. In the original workbook, I am using SQL query so I cannot pivot. Is there another way around?
Do you have the ability to modify your SQL query? if so, you can do what Jim recommended above, just in SQL. Here are instructions on pivoting data in SQL: