Pivot table

  • Thread starter Thread starter annie
  • Start date Start date
A

annie

need yr help am not be able to have a total # appeared for
q2 and as well as q3 , q4 and so on in Pivot table kindly
help

q1 q2
1 1
3 3
2 2
3 2
2 2
1 2
4 2
1 1
2 2
2 2
4 3

This is how the pivot table look like

Count of q1
q1 q2 Total
1 1 2
2 1
1 Total 3
2 2 4
2 Total 4
3 2 1
3 1
3 Total 2
4 2 1
3 1
4 Total 2
Grand Total 11
 
As I replied to your previous post:

To get the pivot table that you want, you'll have to change the
structure of your data table. It should be set up as:

Operation Qtr Num
Type A Q1 1

To restructure your data, use the "unpivot' technique described by John
Walkenbach:
http://j-walk.com/ss/excel/usertips/tip068.htm

From the restructured data, create a pivot table, with Number in the
row area, Quarter in the column area, and Quarter again in the data area.
 
Back
Top