5 Replies Latest reply: Dec 19, 2014 5:41 AM by Melissa van Kluyve RSS

    Preserve all columns of pivot table

      Hello,

       

      I have a pivot table that I would like to show all columns and rows regardless of filtering. Filtering should change the numbers contained within the columns, though all columns and rows should remain visible, even if a null value is returned.

       

      Is there a setting for this? Currently if I filter my table loses the relevant rows/columns.

       

       

      Thank you

      M

        • Re: Preserve all columns of pivot table
          Marco Wedel

          please post sample app

          • Re: Preserve all columns of pivot table
            AVIRAL NAG

            Hi


            I am not clear with your requirement. For better understanding post your sample Application.

             

            Use "Always Fully Expanded" option under Presentation Tab. See the Snapshot:

            Always Fully Expanded.png

             

            Regards

            Av7eN

              • Re: Preserve all columns of pivot table

                Hi - thanks for the tip. I’m afraid it doesn’t achieve what I am wanting it to though. When I filter, the chart still loses columns with no data.

                 

                Thanks anyway ☺

                 

                 

                 

                 

                IMPORTANT NOTICE

                 

                This communication is from Deloitte LLP, a limited liability partnership registered in England and Wales with registered number OC303675. Its registered office is 2, New Street Square, London EC4A 3BZ, United Kingdom. Deloitte LLP is the United Kingdom member firm of Deloitte Touche Tohmatsu Limited (“DTTL”), a UK private company limited by guarantee, whose member firms are legally separate and independent entities. Please see www.deloitte.co.uk/about<http://www.deloitte.co.uk/about> for a detailed description of the legal structure of DTTL and its member firms.

                 

                This communication contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s), please (1) notify it.security.uk@deloitte.co.uk<mailto:it.security.uk@deloitte.co.uk> by forwarding this email and delete all copies from your system and (2) note that disclosure, distribution, copying or use of this communication is strictly prohibited. Email communications cannot be guaranteed to be secure or free from error or viruses. All emails sent to or from a Deloitte UK email account are securely archived and stored by an external supplier within the European Union.

                 

                To the extent permitted by law, Deloitte LLP does not accept any liability for use of or reliance on the contents of this email by any person save by the intended recipient(s) to the extent agreed in a Deloitte LLP engagement contract.

                 

                Opinions, conclusions and other information in this email which have not been delivered by way of the business of Deloitte LLP are neither given nor endorsed by it.

              • Re: Preserve all columns of pivot table

                Aveen is right. Maxbe you can post your expression, that way we could help you better

                  • Re: Preserve all columns of pivot table

                    Thanks Tibor,

                     

                    I have two dimensions, both which are segmentations defined in the load script, one of which is a cyclical group:

                     

                     

                     

                    My expression is just a sum of volume;

                     

                     

                     

                    On the Presentation tab, I have ‘Always Fully Expand’ selected.

                     

                     

                     

                    Thanks again very much for your help. I’m afraid I can’t post the actual file due to data sensitivity.

                     

                    M

                     

                     

                     

                    IMPORTANT NOTICE

                     

                    This communication is from Deloitte LLP, a limited liability partnership registered in England and Wales with registered number OC303675. Its registered office is 2, New Street Square, London EC4A 3BZ, United Kingdom. Deloitte LLP is the United Kingdom member firm of Deloitte Touche Tohmatsu Limited (“DTTL”), a UK private company limited by guarantee, whose member firms are legally separate and independent entities. Please see www.deloitte.co.uk/about<http://www.deloitte.co.uk/about> for a detailed description of the legal structure of DTTL and its member firms.

                     

                    This communication contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s), please (1) notify it.security.uk@deloitte.co.uk<mailto:it.security.uk@deloitte.co.uk> by forwarding this email and delete all copies from your system and (2) note that disclosure, distribution, copying or use of this communication is strictly prohibited. Email communications cannot be guaranteed to be secure or free from error or viruses. All emails sent to or from a Deloitte UK email account are securely archived and stored by an external supplier within the European Union.

                     

                    To the extent permitted by law, Deloitte LLP does not accept any liability for use of or reliance on the contents of this email by any person save by the intended recipient(s) to the extent agreed in a Deloitte LLP engagement contract.

                     

                    Opinions, conclusions and other information in this email which have not been delivered by way of the business of Deloitte LLP are neither given nor endorsed by it.