I'm a bit confused by this as the Coffee Chain set only has data for 2010 and 2011? To answer this question for 2010 or 2011 you would first need to bring in the Coffee Chain data with the "factTable" as your primary table and a left join to Location (using Area Code) and a left join to Product using Customer ID.
From there you would bring Type and SUM(Sales) into your view and turn the SUM(Sales) into a "Percent of Total" table calculation. Lastly, add a Market filter to only show the East region and a Date filter to pick the year of interest.
If this post assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thank you for your response..
Year is confusing for me too, it's not forecasting question. In fact i did blending with Superstore data and took year as 2012 but no success. I am not getting the answer.
I had the same problem earlier, but came up with a solution, not sure if the method is correct though.
put the year in column shelf, territory in Row Shelf.
Move the sales and calculate % of the total, Then use Type in Filter and select Decaf.
I have used only Coffe chain dataset.
Let me know if this helps.