Hi,
I've got a view of sales by week (Actuals), and another view of difference from previous week (WoW difference) broken down by sub-category. Both are horizontal bar charts. Both are added to a dashboard.
In the dash, I want to click on one of the bars or dates in the top Actuals view, and show a single view of how each sub-category compares to previous week. Also, when the filter is cleared i want to show the most recent week's comparison to previous week.
Currently i have to select 2 or more dates in the filter and only then do the bars appear. Also they show the former week's comparison to previous week (which is empty) as well as the latter week's comparison. I only want to show the latter week, and also want this to be dynamic.
Hope that makes sense and someone can help me
Tableau verson: 10.2.0
Sam
Hi, Samantha
To your 1st question, yes, you are right. Im being lazy, sorry about that.
To your 2nd question, we need another worksheet which only has the most recent week data. and put both variance worksheet into a Horizontal container
The workbook is updated for your reference.
ZZ
