9 Replies Latest reply: Aug 30, 2013 1:32 AM by Prashant Adhav RSS

    Incorrect Subtotals in Pivot Table

    Nisha Nangalia

      I have two tables

       

      Table A 

      Country 

        Model

       

      Table B

      Model ( Few Models )

      Cost

       

      When I Left Join Table A with B  for some Model which are not in table B Cost is
      null. And when I use Pivot table to calculate count(Model)*Cost
      and try to get subtotals I get 0.

       

      Table A                                 Tableb

      Country  Model                Model                   Cost

       

       

                           A                           a                           10

                           A

                     

                          b                            e                          14

       

       

      ABC           e                             f                           12

                           e

       

                         F

       

       

         XYZ           a

       

       

                      b            

      Can you please help me to get proper subtotals.