3 Replies Latest reply: Dec 6, 2012 12:37 AM by NRB RSS

    Reg Pivot tables

    NRB
      Hi Experts,

      We have 5 columns in the pivot tables and 2 columns excluded in the remaining 3 columns 1 column is depending on the excluded columns i.e. actually it as to show values in 1000's due to the impact of the excluded columns it is showing in some lakhs.

      So how to make the excluded columns should not impact on remaining columns.

      Thanks,
        • 1. Re: Reg Pivot tables
          prassu
          Dont exclude the column just hide it.

          thanks,
          prassu
          • 2. Re: Reg Pivot tables
            NRB
            Hi ,

            By hiding the columns the 3rd column will show the same data how we can reach the requirement.

            We have 5 columns in the pivot tables and 2 columns excluded in the remaining 3 columns 3rd column values are depending on the excluded columns values due to that it is showing some complex data how to remove the impact of excluded columns in the rows section columns(i.e. 3rd column) .

            i think requirement is clear.


            Regards,

            Edited by: RAJ.bi on Dec 4, 2012 11:20 PM

            Edited by: RAJ.bi on Dec 4, 2012 11:22 PM

            Edited by: RAJ.bi on Dec 4, 2012 11:23 PM
            • 3. Re: Reg Pivot tables
              NRB
              Hi Experts,

              Can i have any updates/Suggestions on this.

              Regards,