I tried your idea but I am working with a database from SAP BW and can only use Dimension as source field in filter action.. It's too bad because your idea seems to work.
hmm, so you don't even see those created calculated fields? Or they are grayed out?
Unfortunately, I can't even see them.
What is it exactly what you want to do? Filter a year from your data?
Like, if you select may 2011, you only want to see 2011? Because this just sounds like a year filter to me, or am I missing something here?
Could you explain it like this:
- What you want (Filter for a calendar year/fiscal year/year before selected date/Month etc)
- Which decision/selection you make (Select a certain month of year/select year/etc etc)
- How you would like the result returned?
Right now it seems to me, if you just want to be able to filter "My sheet" for year. Selecting the month doesn't seem relevant because you just want to see the whole year?
If so, then create a parameter called Year and 3 dimension filters (I named them Filter (<-- use that one on the filter shelf and set it to "True"), All and Year filter). I also made the title dynamic, to reflect for which year you are viewing the data.
You can then just use this "Filter" filter on which ever worksheet you want, to filter all the sheets with just this parameter.
I have added my attempt to solve your problem in the "Solution?" worksheet and dashboard.
I can't see your workbook, maybe you can upload it again to help other people in my case? Sorry it was quite hard to explain what I wanted to do but Ville surely got it!
Ville's workbook will explain better what I wanted to do. The dual axis is an excellent trick and is working for me.