Why does the requirement exist for both Year and current last two months exist to appear on the same page? I can not think of a quick way to do this in a single visualization without filtering at the data level and making al data sources for each year and connecting them on Segment (see below picture). The 2013 data source is filtered at the data source to only contain 2013 data and then 2014 has only 2014 data. I have attached a copy of the workbook however it is in 10.1 as I do not have a local copy of 9.0 running. You can run both 9.0 and 10.1 on the same license and on the same pc however if you wish to review.
I have also created a dashboard view which is off a single data source and takes very little time to create.
Sample data pv.twbx 1.4 MB
1) What do you want the headers to be? Are you ok with this year/last year this month/last month or do you want them to be specific like November 2014, December 2014?
2) Are you ok with using a small "scaffold" data source?
I originally set up dynamic month calculations along the lines of IF[Date] = MAX[DATE] then [Data] ELSE 0 END, and then I named this 'latest month'.
However the client didn't want to see a column titled 'latest month', they wanted the actual month name in the column. The only way I could achieve this was to filter the data for the last 2 months, then try a LOD for the year.
Thank you for your help, I am still relatively new to Tableau and this forum is a really helpful feature.
Sorry also meant to add that I only started learning about data scaffolding yesterday, would it help here?
I will try to duplicate the data sources and filter them as you suggest. Originally I tried to overlay a year sheet on a month sheet in the dashboard, however there are a number of metrics per month and these could not fit into a single page together. I then found out that Tableau does not have a feature that synchronises scrolling across two worksheets on a dashboard.
I will try duplicating and filtering the data sources as you have, I wasn't aware that I could run both Tableau versions on the same license either, so that's really good news.
Thanks very much for your help.