Pivot table should not collapse

[Anonymous]

Hi All,

As per requirement whenever I click on the 'CATEGORY' it should not collapse and move on to next sheet and Current Selection persist.

please find attachments for reference.

Suggest plz

Thanks

Manish Madan

[#2]

use the expression like

sum({1},0)  check this once

[SunilChauhan]

still i dont understand your requirement

but i hope

allow fully expanded in presentation tab of chart properties will helps you

hope this helps

[karolina_]

I'm not sure either about your requirement. You might need to check "read only" on 'general' tab in chart properties

[Anonymous]

Thanks Rao,Sunil and Karolina for your help and suggestions.

Elaborating again in more details as you can see my attachment, what i want is when i click on the category values it is collapsing and displaying the current selection which i don't want , what i want is to it change the graph on my selection also and there should not be any impact on pivot table it should all the categories and Catelog's.

i got the solution for this i wrote an expression:

FOR:ALL_ITEMS

sum({<[CATALOG] = ,[CATEGORY]=>}ALL_ITEMS )

INVALID_ITEM:

sum({<[CATALOG] = ,[CATEGORY]=>}INVALID_ITEM)

Thanks again for your help,let me know if i could also help u all in any manner.