Hi,
I've got a bit of a unknown situation.
I have a simple cube based pivot table, that displays gross revenue from a date dimension.
SO the table will be something like this
Year 2013/2014 £400
FQ 1 2013/2014 £400
May 2013 £400
01/05 £200
02/05 £200
.
.
.
.
31/05
June 2013
01/06
02/06
In the example below, YEAR & QUARTER are collapsed, and MONTH is expanded to show me all the dates.
The Hierarchy would look something like this
Year 2013/2014FQ 1 2013/2014May 2013June 201301/06My question then is02/06
Is there a way I can Auto collapse the Month of June, once I enter July?
So uptill the 31st May, I still have the Month of May showing me all 31 days of that month, but as soon as June starts, month of May Collapses and June lists all the days?
Thanks in advance
Dave
Bookmarks