software

Is it possible to make a pivot table that doesn't change the data? I want it
to show the original data and not Count, Sum up ...

The data consists of text and numbers!

Hi Roy

You can drag all of your fields to the row area, and not allocate
anything to the data area.
You will then see all of the original data going across the page, in the
oder that you have arranged the fields in the row area.
Double click on each field and set the subtotal to None.

I use this as a quick and easy method of sorting out tasks, rather than
sorting and filtering data.
I have a Start Date column, Required by Date column, Task type column
and Notes column.
Getting the Required date field to be grouped by Month, then gives a
nice orderly presentation of what is to be done and when. The filter
buttons then allow me to select which, group of task I want to view.
I just hide the columns on the sheet where the PT data would normally
sit, so I don't see an empty rectangle.

--
Regards

Roger Govier
Roy Boelens wrote:
gt; Is it possible to make a pivot table that doesn't change the data? I
gt; want it to show the original data and not Count, Sum up ...
gt;
gt; The data consists of text and numbers!
Thats not exactly what I meant. Bu than anyway.

This is how my data is stored:

ItemOrganisation codeCategory set nameCategory
129250AA 567 COO CA
129250AA NL1 COO CA
129250AA NLV COO CA
129250AA 567 DTC 8481
129250AA NL1 DTC 9032
129250AA NLV DTC 8481
......

I want it to be sorted like this:

COODTC
ItemA B C A B C
129250AA CA CA CA 8481 9032 8481
......

The problem is that the Pivot table hasn't got a option that only displays
the text, it uses a calculation like SUM, or COUNT or something.

quot;Roger Govierquot; wrote:

gt; Hi Roy
gt;
gt; You can drag all of your fields to the row area, and not allocate
gt; anything to the data area.
gt; You will then see all of the original data going across the page, in the
gt; oder that you have arranged the fields in the row area.
gt; Double click on each field and set the subtotal to None.
gt;
gt; I use this as a quick and easy method of sorting out tasks, rather than
gt; sorting and filtering data.
gt; I have a Start Date column, Required by Date column, Task type column
gt; and Notes column.
gt; Getting the Required date field to be grouped by Month, then gives a
gt; nice orderly presentation of what is to be done and when. The filter
gt; buttons then allow me to select which, group of task I want to view.
gt; I just hide the columns on the sheet where the PT data would normally
gt; sit, so I don't see an empty rectangle.
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt;
gt; Roy Boelens wrote:
gt; gt; Is it possible to make a pivot table that doesn't change the data? I
gt; gt; want it to show the original data and not Count, Sum up ...
gt; gt;
gt; gt; The data consists of text and numbers!
gt;
gt;
gt;

Hi Roy

The best I could come up with is

Category Set Name Item Category Organisation Code
COO 129250AA CA 567
NL1
NLV
DTC 129250AA 8481 567
NLV
9032 NL1This was achievd by pulling all the filed headings to the row Area, in
the order as above, then drgaiing Category to the Data area as a count.
All Fields were set to None for Total, Table Options are set to No Grand
Totals for Rows or Columns. I just hid the column showing the Count.

--
Regards

Roger Govier
Roy Boelens wrote:
gt; Thats not exactly what I meant. Bu than anyway.
gt;
gt; This is how my data is stored:
gt;
gt; Item Organisation code Category set name Category
gt; 129250AA 567 COO CA
gt; 129250AA NL1 COO CA
gt; 129250AA NLV COO CA
gt; 129250AA 567 DTC 8481
gt; 129250AA NL1 DTC 9032
gt; 129250AA NLV DTC 8481
gt; .....
gt;
gt; I want it to be sorted like this:
gt;
gt; COO DTC
gt; Item A B C A B C
gt; 129250AA CA CA CA 8481 9032 8481
gt; .....
gt;
gt; The problem is that the Pivot table hasn't got a option that only
gt; displays the text, it uses a calculation like SUM, or COUNT or
gt; something.
gt;
gt; quot;Roger Govierquot; wrote:
gt;
gt;gt; Hi Roy
gt;gt;
gt;gt; You can drag all of your fields to the row area, and not allocate
gt;gt; anything to the data area.
gt;gt; You will then see all of the original data going across the page, in
gt;gt; the oder that you have arranged the fields in the row area.
gt;gt; Double click on each field and set the subtotal to None.
gt;gt;
gt;gt; I use this as a quick and easy method of sorting out tasks, rather
gt;gt; than sorting and filtering data.
gt;gt; I have a Start Date column, Required by Date column, Task type
gt;gt; column and Notes column.
gt;gt; Getting the Required date field to be grouped by Month, then gives a
gt;gt; nice orderly presentation of what is to be done and when. The filter
gt;gt; buttons then allow me to select which, group of task I want to view.
gt;gt; I just hide the columns on the sheet where the PT data would normally
gt;gt; sit, so I don't see an empty rectangle.
gt;gt;
gt;gt; --
gt;gt; Regards
gt;gt;
gt;gt; Roger Govier
gt;gt;
gt;gt;
gt;gt;
gt;gt; Roy Boelens wrote:
gt;gt;gt; Is it possible to make a pivot table that doesn't change the data? I
gt;gt;gt; want it to show the original data and not Count, Sum up ...
gt;gt;gt;
gt;gt;gt; The data consists of text and numbers!
That did not come out very well with the formattuing getting screwed up.
The last column comes out as
567
NL1
NLV
567
NLV
NL1--
Regards

Roger Govier
Roger Govier wrote:
gt; Hi Roy
gt;
gt; The best I could come up with is
gt;
gt; Category Set Name Item Category Organisation Code
gt; COO 129250AA CA 567
gt; NL1
gt; NLV
gt; DTC 129250AA 8481 567
gt; NLV
gt; 9032 NL1
gt;
gt;
gt; This was achievd by pulling all the filed headings to the row Area, in
gt; the order as above, then drgaiing Category to the Data area as a
gt; count. All Fields were set to None for Total, Table Options are set
gt; to No Grand Totals for Rows or Columns. I just hid the column showing
gt; the Count.
gt;
gt; Roy Boelens wrote:
gt;gt; Thats not exactly what I meant. Bu than anyway.
gt;gt;
gt;gt; This is how my data is stored:
gt;gt;
gt;gt; Item Organisation code Category set name Category
gt;gt; 129250AA 567 COO CA
gt;gt; 129250AA NL1 COO CA
gt;gt; 129250AA NLV COO CA
gt;gt; 129250AA 567 DTC 8481
gt;gt; 129250AA NL1 DTC 9032
gt;gt; 129250AA NLV DTC 8481
gt;gt; .....
gt;gt;
gt;gt; I want it to be sorted like this:
gt;gt;
gt;gt; COO DTC
gt;gt; Item A B C A B C
gt;gt; 129250AA CA CA CA 8481 9032 8481
gt;gt; .....
gt;gt;
gt;gt; The problem is that the Pivot table hasn't got a option that only
gt;gt; displays the text, it uses a calculation like SUM, or COUNT or
gt;gt; something.
gt;gt;
gt;gt; quot;Roger Govierquot; wrote:
gt;gt;
gt;gt;gt; Hi Roy
gt;gt;gt;
gt;gt;gt; You can drag all of your fields to the row area, and not allocate
gt;gt;gt; anything to the data area.
gt;gt;gt; You will then see all of the original data going across the page, in
gt;gt;gt; the oder that you have arranged the fields in the row area.
gt;gt;gt; Double click on each field and set the subtotal to None.
gt;gt;gt;
gt;gt;gt; I use this as a quick and easy method of sorting out tasks, rather
gt;gt;gt; than sorting and filtering data.
gt;gt;gt; I have a Start Date column, Required by Date column, Task type
gt;gt;gt; column and Notes column.
gt;gt;gt; Getting the Required date field to be grouped by Month, then gives a
gt;gt;gt; nice orderly presentation of what is to be done and when. The filter
gt;gt;gt; buttons then allow me to select which, group of task I want to view.
gt;gt;gt; I just hide the columns on the sheet where the PT data would
gt;gt;gt; normally sit, so I don't see an empty rectangle.
gt;gt;gt;
gt;gt;gt; --
gt;gt;gt; Regards
gt;gt;gt;
gt;gt;gt; Roger Govier
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;gt; Roy Boelens wrote:
gt;gt;gt;gt; Is it possible to make a pivot table that doesn't change the data?
gt;gt;gt;gt; I want it to show the original data and not Count, Sum up ...
gt;gt;gt;gt;
gt;gt;gt;gt; The data consists of text and numbers!