I have two questions
1) Do all of these need to be on the same worksheet? It's easy enough to put each segment into a worksheet, then put all three of them into a dashboard.
2) When you say you want to filter measure on some segments, are these filters that the user will need access to?
Superstore_Revised.twbx 320.8 KB
Thanks very much for your prompt response.
1. Yes preferably on the same worksheet. The attached file is a dummy data. The actual data has a lot of Segments which will have a scrollbar in the end.
2. These filters will not be chosen by user interacting with the views.
Thanks very much!
Yes, it's possible.
To get this, first I joined the data with a list of the measure names, Profit, Quantity and Sales.
I have then created a calculated field called Segment + Measure which is a concatenation of the Segment and Measure field. I used this to filter out the combined value which I do not need.
Finally, I have a calculated field as shown below to derive the value.
Hope this helps. Updated workbook is attached.
Superstore.twbx 385.1 KB
Hello Hari Ankem,
Thanks so much!!
This looks like a solution to this but is there a way to work around this without joining another table?
Well, you can explore, and it may be possible but could lead to complications. And, I prefer simple and easy solutions.
From your solution it looks like it's always summing the measures. I run into problems since with what I have each measure has it's own aggregation as well as different number formats.
It need not be sum only. You can modify it.