Open the world of Pivot Tables
in [General]
|
Prev: Run numerous calculations through a single formula
Next: How do I autofit row height to adjust to new text on Excel form?
From: Debster on 17 Feb 2010 09:50 I have been using pivot tables for quite some time now, and in my opinion the world of pivot tables can be expanded greatly by the opportunity to allow "alpha" data to be reported back in the values section. I know - unconventional, but see example below: Raw Data: NAME CITY PROVINCE GEORGE TORONTO ON PAULA VANCOUVER BC FRANK REGINA SK SAM MONTREAL QC TYLER SUDBURY ON BRITTANY ST. JOHN NF BILLY CHARLOTTETOWN PEI Pivot table layout: Column label: Province Row label: Name Value City Requested results Province Name BC NF ON PEI QC SK Billy Charlottetown Brittany St. John Frank Regina George Toronto Paula Vancouver Sam Montreal Tyler Sudtury ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/community/en-us/default.mspx?mid=7b68a4dc-4ba2-4f8d-b303-78b4d594fded&dg=microsoft.public.excel.misc
From: Herbert Seidenberg on 17 Feb 2010 11:45
Excel 2007 PivotTable with text While MS is busy, try this: http://www.mediafire.com/file/zj5zzeuxtmk/02_17_10.xlsx |