I have a data view which needs data entry for a particular month, but I also want to display a trend of data leading to the current month.
This is simple enough using the Period Offset function and selecting only the month that is needed for data entry, however, I then cannot put months in the column axis and hence cannot display the month name in the title of the column.
My work around at the moment is to rename the block PM for Prior Month, PM-2 for two months ago, etc. But this is less than ideal.
Any way to get this to work?