I want to show in a dynamic report and in a dynamic input schedule values for different versions ACT and PLAN via Excel client.
In the rows are entity, time (for 2009, 2010, 2011) and version. And in the columns are special time dimension to show month. Sounds very strange - and it is so... Now I want to show only values for ACT for year 2010 and PLAN for 2011.
How can I enter the dimension within the expansion area? Is there a way to combine 2 different dimensions like a statement "where time is 2010 and version is ACT"?
Thank you very much for your ideas