I am trying to create a simple table that shows a few metrics as columns and regions as rows. I would like each metric to show me values for 2020, 2021 and % difference between those years.
I have encountered a problem which will be easier to show - please take a look at the screesnhot below:
I have added quick calculation that gives me a % difference but I don't like how it is presented. I would like %diff to be in a column next to 2021 and within Profit column. Is this possible to do inside a single worksheet? (I know that I could stitch multiple worksheets inside a dashboard to achieve this but that is something I don't want to do unless there isn't any simpler way).
The end result I have in mind is that rows stay as they are but columns change to just profit and columns on the lower level are only 2020 | 2021 | % diff, but I don't know how to do this inside a single worksheet. The next step would be adding other measures that would keep Profit's breakdowns but this step should be fairly easy to replicate for other metrics once there is a working solution for one measure (in this case Profit)
Attaching a workbook from screenshot that uses sample - superstore
Hello @Steve Martin
Not really, this picture below is what end result I would like to have:
Please excuse the black bars, I hope that structure of the table is still visible. I was trying to build a table like that in a "Sheet" but I couldn't find any solution so I had to use multiple "Sheets" and then stitch them up in the "Dashboard" to get the end result I wanted.
My approach works but feels hacky and isn't convinient to reproduce so I am trying to find an alternative
