To create this type of view we'll need to use discrete calculated fields for Quantity to get the headers. I only did calcs for Quanity but these can be duplicated and you can plug in however many other measures you would like to see. The sparkline is showing the Profit values over time.
To find the latest week and prior week I used some LOD calculations. Hopefully this is helpful for building your final view
sparklines for philip.twbx 1.2 MB
I'm not sure I understand how I would add more measures into this view you created? If I duplicate the discrete calculated fields, that will add columns. I was hoping to just how those 4 discrete calcualted columns, but for each row that is a different measure it relate to that measure (say quantity, then sales, etc).
My current workaround which isn't too bad is to create multiple tabs and put them in one dashboard. It is just a bit tedious.
Thanks for your help.
+1 on this question!
Did you ever find a solution Philip? I'm trying to do the same exact thing
I have not. If I remember correctly i went the route of creating a dashboard with multiple tabs, etc.
That's what I might end up doing too.
thanks for the reply