![]() |
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 |
All times are GMT +1. The time now is 05:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com