Problem in pivot table vs CG

[#1]

I think, This is a bug.

I have used the 4 cyclic group in pivot table.

Cg:

       1. Part (PartNo, PartDesc)

       2. Customer  (CustomerName,CustomerID)

       3. actualCalendar(Year week month)

       4. fiscal calendar (Year week month)

Expression Sum(Amount)

and I make last 2 cg data (actual calendar, fiscal calendar) as a column (drag and drop as a column) and I gave enable condition for that two cg respectively Isactualcalendar=1 for actualCalendar and Isfiscalcalendar=1 for FiscalCalendar(this variable is changing while clicking button , so that any one calendar cg shows at a time).

And now my issue is I am not able to change the dimension for fiscal calendar in that report(I got popup 'dimension list' and if click on it then nothing happen.) , I can change the Actualcalendar dimension.

it is working fine when we have a all cg as a column(with out drag and drop).

Please help me on this.

Regards,

Kabilan K.

[#2]

can you post a qvw file

[#3]

PFA.

[#4]

I am able to select the dimensions in both CG3(A_Year,A_Week) and CG4(F_Year,F_Week) as per the visibility.

This is what i did:

Clicked on "SwitchActualCalender" button

-> Chart showing CG1,CG2,CG3

-> In CG3, i am able to select either of the dimensions avaiable in CG3

Clicked on "SwitchFiscalCalender" button

-> Chart showing CG1,CG2,CG4

-> In CG4, i am able to select either of the dimensions avaiable in CG4

Hope,I am clear !

[#5]

Pivot table how is it looks?

Can u share the screen shot?

after changing the dimension see whether table the correct dimension or not?

Regards,

Kabilan K.

[#6]

Which version are u using?

[#7]

I am using 11 SR2

PFA the screenshots

[#8 · Accepted solution]

We are using SR1. So they are recover this problem in SR2