Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
use the expression like
sum({1},0) check this once
still i dont understand your requirement
but i hope
allow fully expanded in presentation tab of chart properties will helps you
hope this helps
I'm not sure either about your requirement. You might need to check "read only" on 'general' tab in chart properties
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.