4 Replies Latest reply: Mar 10, 2010 12:16 PM by RickJRed3 RSS

    Cross-footing pivot table totals


      I'm creating a trial balance with the account, year and period as dimensions. I put the periods, Jan-Dec, on top, the account and year on the left and want to get a cross-footed total of all periods in the year. I can't figure this out and would appreciate some help. Thanks.


        • Cross-footing pivot table totals
          Gajapathy R


          I hope you want to move the Period in the top of the Pivot table. First you need to add the Period in the Dimension and after creating the Pivot table you select the Period column and drag into above the Amount column. When you drag the column you will see a Arrow point which will indicate where the new position for the Period.

          Attached the sample file for your reference. Hope this will resolve your problem.