Item Variance in a Table

Good Morning,

  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?


(1) Answer