pivot tables

S

Suburbia

Hi, I need you help, please, because I don´t find any solution to this:

I have 5 columns. Column A has company names. Column B has months. C and
D have items.


A B C D
Company Month Item1 Item2
Microsoft
1
2 0
4 2
3 1
4 3

I would like to get in cells C2 the sum of item1 along the year.
And in C3 the sum of the item in the first month of the year.

I don´t know how to do it.

any help?

Thanks!
 
D

Debra Dalgleish

In the pivot table, double-click on the Company button
Click the Layout button
Select 'Show items in Outline form' and add a check mark to
'Display subtotals at top of group'
Click OK, click OK

Or, select a cell in the pivot table, and choose Format>AutoFormat
Select one of the Report layouts that has subtotals at the top, click OK
 
S

Suburbia

Thank you very much indeed !!!

Debra Dalgleish said:
In the pivot table, double-click on the Company button
Click the Layout button
Select 'Show items in Outline form' and add a check mark to
'Display subtotals at top of group'
Click OK, click OK

Or, select a cell in the pivot table, and choose Format>AutoFormat
Select one of the Report layouts that has subtotals at the top, click OK
Click to expand...
 
Top