For pivot table I need one option like
I have dim1, dim2, dim2, and expression
when I click on + symbol on dim1 then all the values should expand I should not expand each and every plus symbol on dim1, dim2 like that
Expand All the the fields & then right click on column 1 and select collapse all. Now when you'll click on expand it will expand all the fields.
is it dynamic/permanent for all the users on accesspoint ?
I want every time to be there for all the users
I guess yes, but you need to test.
Why cant you use Always fully expand check in Pivot table Presentaion tab. Like below?
users are not looking for always expand, they want when they click on first dimension + then that particular data should be expand all
for ex below if user select b then data should come like below expand all
Didn't my trick work for you??
no, when we close document and if you open it is not working,
Check this out. It works on my end.
what changes you have done, pls tell me
I am not sure why it is not working for you. It works on mine (desktop version as well as Access point).
Sorry, can't figure out what is the issue, may be someone else will .
It works for me too. Priya, can you try on your local desktop and in Access Point too and let us know.
I believe it is because you use access point to view your dashboard. I am not sure if that holds the expansion.
let me check on access point tomorrow till it is working on desktop, thanks for all your support
Retrieving data ...