Create the variable based on your requirement and add it in view.
like sales with
Please see the attached workbook.
You can create some calculated fields which uses an if statement.
Please see the attached where I have created 3 new calculated fields:
I then created two worksheets, one with the regional sum of sales and the other sheet using the 3 calculated fields.
I then brought in both worksheets into one dashboard:
Please let me know if this is useful. If this has answered your question, please mark this answer as correct.
Regional.twbx 38.6 KB
Thanks for the workaround, even I was following the same but I need all those 7 values under Region which I'd use it as a filter.
So I have to create a new dimension with seven values!
Thanks & Regards,