1 of 1 people found this helpful
If you put Profit Ratio on a separate sheet with the same layout, with "Show Headers" unchecked for the dimension headers and a different YEAR(Date) filter on each sheet you can then combine them on a dashboard. The resulting dashboard is attached and shown below. This has its limitations, as well, and there's probably a way to get this in one sheet but I knew this was one approach to get at what you wanted: Hopefully a guru will show us another simpler approach.
Note I didn't bother lining up the values, but we could line everything up if we worked at it a bit.
I did this in Version 8.1, not Version 8.0, but the process would be the same. If you're unfamiliar with that process, and think this would work for your scenario, I can explain it in more detail. One complication is exporting to Excel will have to be done on a per-sheet basis; there are other implications of using two sheets as well.
8.1 workbook attached.
Thanks for such a quick response Matthew. In the actual workbook, we have more calculated fields in the table with a few dimension filters, and this is all part of a larger dashboard. I'm hoping to avoid piecing together the table out of multiple worksheets, but it's a good idea if there isn't a single sheet solution!