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,