1 Reply Latest reply: Aug 17, 2011 3:34 AM by Jaanus Muruõis RSS

    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?

       

      Can this be done?

       

      Phil

        • Can I have the third dimension of a pivot table always expanded?

          I have the same prob.

           

          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!

           

           

          Thanks ahead!

          Jaanus