Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
PivotTable without data calculations?
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
PivotTable without data calculations?
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
PivotTable without data calculations?
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
PivotTable without data calculations?
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! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
PivotTable without data calculations?
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PivotTable Data Series Formatting | Charts and Charting in Excel | |||
How do I count unique items in a pivottable data field. | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Updating calculations automatically when i enter in new data | Excel Discussion (Misc queries) | |||
Updating calculations + graph when i enter in new data WITHOUT OFF | Excel Worksheet Functions |