This can be done by following the instructions in the above KB article. However, the month will have to be added to the set. I have attached a sample workbook using the Superstore sample.
Hope this helps!
cat, prod, month.twbx.zip 1.1 MB
I have an additional question for another view I'm trying to build. Taking the same example you provided, would it be possible to see top 10 products sold by category this year, how much they sold last year and then compute the YOY difference?
I followed your approach and created a set for category, Year and Product Name, and then put the Year in the columns tab in a bid to see 2011 and 2012 sales numbers side by side for the top 10 products sold in 2012. I'd like to then calculate the YOY based on this text table view. Is this possible?
Thank you very much for your time indeed.