Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Hari
 
Posts: n/a
Default Pivoting for the sake of look

Hi,

My colleague has some raw data and he wants to make a pivot out of it
such that the full data is represented in pivot (no summarization like
Sum, product etc is to be done). Why? Am not sure of the reason but it
seems his boss is comfortable working with a pivot or probably in case
of repeating values in raw data, the row field values display the data
only once and probably that is considered as good? (or probably one has
the luxury of looking at subsets of raw data via applying pivot
filters)

So, my doubt is as to whether we can make a pivot with lets say 8 page
fields, 2 rows fields (no column field) where the data field has no
sumarization values. Rather all the rows from raw data which meet the
critirea of selections in page field and row field would be displayed.

Is this feasible (or sensible)?

Please guide me.

Regards,
HP
India

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivoting - Problem Jose m via OfficeKB.com Excel Worksheet Functions 1 August 9th 05 05:41 PM


All times are GMT +1. The time now is 07:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"