It's little bit troublesome, but considering the VIZ beauty, below approach should be good.
[SM 2015 Score]
if [Year]=2015 then [Score] end
[SM 2016 Score ]
if [Year]=2016 then [Score] end
sum([SM 2016 Score ])-sum([SM 2015 Score])
Growth Example_SM_9.3.twbx 53.6 KB
You can use multiple axis on the columns shelf . Each axis will have its own set of properties (Color and Label shelf).
In the attached example, I use a dual axis setup in order to be able to set a column header.
Check the axis configuration (right-click green pill - Edit axis) in order to set the header name and cell size.
Use the xcell Color shelf to set the color of the cells.
Use the xvalue to set and format the label.
In this scenario you cant have the Year in the filter , instead there are 2 parameters to select the two dates we want to compare. The score for each Year have their own calculation , and are dragged on the label shelf of their respective xvalue axis.
Growth Example ed mc.twbx 67.2 KB
Oh wow! Those are both such great solutions - I love the way they look and they do exactly what I wanted them to do. Is there any way to mark both solutions as "Correct"? I'm going to try both out on my real data right now and see which works best. This is really great! I appreciate this feedback.