Hi Felix - I dont think its unusual behaviour because you are selecting two different levels of detail in terms of time period and presenting both in the analysis.
At the second level of your date hierarchy you only have Feb 2012 and March 2013 and this is displayed in your chart (Feb = approx $12m and Mar $10m).
However you then also have CY 2013 Q1 selected so I think you are also going to see the sum of data for the whole quarter. As your data for Feb and March totals somewhere in the region of $22m i would hazzard a guess that Jan totals somewhere around $11m which is why the column for CY 2013 Q1 shows a total of $33m
You made a very good point. I came from the MS Excel background and the hierarchy filter works very different compare to this. For instance, when I select the CY 2003 Q1 in Excel it basically auto select all the months within and present to the analysis rather than give an extra subset result.
I guess I am just barking at the wrong tree however, is there any way I can hide some of the hierarchy level in the filter say I want the user only can select Month only rather than give them a full list Year,Quarter, Month?
Off the topic, do you know how I can use the relative date filter in this Date filter as I can only see the basic filter options. The reason I asked is because I needed to have a dashboard to show last 2 weeks from the date the dashboard refreshed or possible all the tableau date filtering features.