Item Variance in a Table
I am attempting to recreate the below table in Spotfire. The center column that is obscured are the item descriptions. Each row of data in the database is setup with columns [Year], [Month], [Item Description], [Cost]. The analysis should have the user choose a month and it compares the current month with the current month last year and then also the year to date with the year to date last year. I was able to create the monthly columns and the YTD columns using data limiting but I am a bit perplexed as to how to have the columns work. What would you recommend?