Pivot table

  • Thread starter Thread starter tommorgan
  • Start date Start date
T

tommorgan

I wish to create a pivot table using four columns such as

Category Gross GST
Nett
Phones $200.00 $25.00
$175.00
Vehicle $452.00 $52.01
$399.99
Wages $825.00
$825.00

I drag the category field to the "drop row fields here" area no problem, but
the other 3 field options of Gross, GST and Nett do not seem to work when
dropped in either of the column fields or data items boxes, what simple
mistake am I making.

Thanks for any help,
 
Category should go into the row area, and the other three fields should
go into the data area of the pivot table, where the amounts can be summed.
 
Back
Top