PivotTable without data calculations?

[Roy Boelens]

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!

[Roger Govier]

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:
> 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!

[Roy Boelens]

Thats not exactly what I meant. Bu than anyway.

This is how my data is stored:

Item Organisation code Category set name Category
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:

COO DTC
Item A 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.

"Roger Govier" wrote:

> 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:
> > 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!
>
>
>

[Roger Govier]

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 NL1


This 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:
> Thats not exactly what I meant. Bu than anyway.
>
> This is how my data is stored:
>
> Item Organisation code Category set name Category
> 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:
>
> COO DTC
> Item A 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.
>
> "Roger Govier" wrote:
>
>> 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:
>>> 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!

[Roger Govier]

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:
> 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 NL1
>
>
> This 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.
>
> Roy Boelens wrote:
>> Thats not exactly what I meant. Bu than anyway.
>>
>> This is how my data is stored:
>>
>> Item Organisation code Category set name Category
>> 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:
>>
>> COO DTC
>> Item A 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.
>>
>> "Roger Govier" wrote:
>>
>>> 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:
>>>> 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!