How would I go about creating a Matrix type chart where there are N columns with cost for each month going back from today and one extra summary column showing % change of the current month since a month before ? For example:
--------| Cost October 2018 | Cost November 2018 | Cost Today | % change
Item 1 |
Item 2 |
I see two options which don't quite do the trick:
1) Put a date column into Columns field in a Matrix chart and Cost and % change columns into Values field. This enumerates both Values items for each date. I only need the % change to be there once and at the end.
2) Create a measure for each month and put all in as Values. This does create layout I want, but it doesn't specify a date in the column name.