Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can i use the pivot dimensions as a filter for quick acces to dimensions.
Please explain your issue a bit more.. it is not clear what is your issue.. if possible put some example also.
Hi,
For filter ,You could use list box.Take the dimention in list box "field".
Thanks.
I have 4 level dimensions on the pivot table.
Level1, Level2, Level3, Level4.
I want to use these dimensions like a list box filter..
and I want to expand the desired level dimension on these filters.
Many thanks..
I don't want dimensions values on the list box.
I have 4 level dimensions on the pivot table.
Level1, Level2, Level3, Level4.
I want to use these dimensions headers like a list box filter..
and I want to expand the desired level dimension on these filters.
Thanks.
hi,
Try this:
goto presentation tab.. there just select the dimension and check the Dropdown select checkbox.
HTH
Sushil
Thank you very much, but unfortunately not helping.
There are so many records in each dimension and i don' t want to see these records on the dropdown menu.
I want to see only desired level dimension to expand.
Thanks..
Please explain your requirement with some example or screen shots..
i am not getting the meaning of "desired level dimension".
~sushil