Can I have the third dimension of a pivot table always expanded?
Hi Everyone,
I have a pivot table with 4 dimsions Division, Station, Date and Incident Number.
Its in this order becasue that is how people want to drill down through the information. But I wondered if it was possible to always show the incident date and number as beign fully expanded as soon as you clicked on the station name perhaps?
I have pivot tabele where on the left side there are usual dimensions for users to collapse and expande (so i can't use Always Fully Expanded from pivot's Presentation Settings),
but on the top I have two dimensinos that should always be fully expanded. How could I do it?
The top dimendions are:
1. Chart name (it includes information about the chart name and seleced period etc..)
2. Year / Month (it includes periods)
These dim. must be fully expanded because else the user would see EOM balances of many month's in total - it would be a total non-sense!
