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/2014
FQ 1 2013/2014
May 2013
June 2013
01/06
02/06
My question then is

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