For the Sales <100 or >=100, I created a Group based on Sales.
For the Percent Change, I created 3 formulas. There is probably a more efficient way but this works...
If Year([Date]) = 2012 then [Sales] end
If Year([Date]) = 2011 then [Sales] end
See attached Visualization.
Count If Visualization.twbx.zip 32.5 KB
Thank you Hilary,
That solves my question to build a first graph. Is there a way to create a graph for % of total stores that have improved sales in 2012 from 2011?
Grouping may be the answer like the way you did it for the first grapg but it seems that calculated results can't be grouped. Thanks.