Pivot Tables - Can you just list data and not SUM
 

Hi All,

I have some data that i have exported from accounting software please see
below.

STK CODE STK DESC UNIT PRICE QTY NET PURCHASE DATE
ZZ01 Whole Bulk Milk 0.30 23703 £7,151.20 02/06/2008
ZZ02 Semi Bulk Milk 0.30 26618 £8,030.65 03/06/2008
ZZ03 Skimmed Bulk Milk 0.30 28504 £8,599.66 04/06/2008

I woulde like to generate a report based on this data grouping by STK CODE
then listing the other fields sorted via the date with a total at the bottom.
Ideally it would be nice to generate this report automatically based on the
raw data. My problem is that if i use a pivot table it either sums/counts
etc the data, but i need to see each line of data as it currrently is above.

Any thought or suggestions or thought on how to do this greatly appreciated.

Mike

Pivot Tables - Can you just list data and not SUM
 

Hey Mike,

Try using Subtotals. Let me know if you need more assistance on this.

Regards
RDX

"mike" wrote:

Hi All,

I have some data that i have exported from accounting software please see
below.

STK CODE STK DESC UNIT PRICE QTY NET PURCHASE DATE
ZZ01 Whole Bulk Milk 0.30 23703 £7,151.20 02/06/2008
ZZ02 Semi Bulk Milk 0.30 26618 £8,030.65 03/06/2008
ZZ03 Skimmed Bulk Milk 0.30 28504 £8,599.66 04/06/2008

I woulde like to generate a report based on this data grouping by STK CODE
then listing the other fields sorted via the date with a total at the bottom.
Ideally it would be nice to generate this report automatically based on the
raw data. My problem is that if i use a pivot table it either sums/counts
etc the data, but i need to see each line of data as it currrently is above.

Any thought or suggestions or thought on how to do this greatly appreciated.

Mike

Pivot Tables - Can you just list data and not SUM
 

Create a pivot table with STK Code, STK Desc, Unit Price and Purchase
Date in the Row area.
Put Qty and Net in the Data area

Turn off all the Subtotals, and that should leave you with just a list
and a grand total.

mike wrote:
Hi All,

I have some data that i have exported from accounting software please see
below.

STK CODE STK DESC UNIT PRICE QTY NET PURCHASE DATE
ZZ01 Whole Bulk Milk 0.30 23703 £7,151.20 02/06/2008
ZZ02 Semi Bulk Milk 0.30 26618 £8,030.65 03/06/2008
ZZ03 Skimmed Bulk Milk 0.30 28504 £8,599.66 04/06/2008

I woulde like to generate a report based on this data grouping by STK CODE
then listing the other fields sorted via the date with a total at the bottom.
Ideally it would be nice to generate this report automatically based on the
raw data. My problem is that if i use a pivot table it either sums/counts
etc the data, but i need to see each line of data as it currrently is above.


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com