pivot table
Hello
Can the data area in a pivot table just be a list of data, not a sum or count etc - if so how can i instruct the table to show the data. list of data eg XX AB 42 TOP RAR Cheers |
Pivot tables are designed primarily for aggregating (consolidataing by sum or
average or...) data. The closest you will get is to toss one of the dimensions (data items) in the data area (count, sum or whatever) and then hide the data area. It is a little cheese but it works. -- HTH... Jim Thomlinson "Joe" wrote: Hello Can the data area in a pivot table just be a list of data, not a sum or count etc - if so how can i instruct the table to show the data. list of data eg XX AB 42 TOP RAR Cheers |
All times are GMT +1. The time now is 12:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com