5 Replies Latest reply: Sep 17, 2018 2:38 AM by Andrey Krylov RSS

    how to Maintain static total & sub total value in pivot table irrespective of the selection

    Shwetha A

      I have data like this and if i load this to pivot table

      Dim1,     Dim2,     Dim3,     Fact1,     Fact2

      A,               AA,     AAA ,     10,          20

      A,               AB,     AC,         6,           12

      A,               AB,     AD,         5,           12

      B,               BA,      BB,        2,           4

       

       

      if we select Dim1=A and Dim2=AB then total for Dim1,Fact1 should be 21. and Dim2, Fact1 total should be- 11

      Required Output:

       

      Dim1Dim2Dim3Fact1Fact2
      A total--2144
      AAB Total -1124
      AABAC612
      AABAD512

      Any idea how to achieve this static values for total and subtotal in pivot table? And it should display only selected dimensions. In this case it should show only A under Dim1, not B.