Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Using Excel 2007, in pivot table, is there a way to put show detail for EVERY
cell? Example: User has raw survey data consisting of one row per respondent; includes ID, question and response. ID....question....response AB...Q1...91 AB...Q2...81 AB...Q3...71 CD...Q1...62 CD...Q2...52 CD...Q3...42 EF...Q1...33 EF...Q2...23 EF...Q3...13 User wants table like this. ID.....Q1.....Q2.....Q3.....Avg AB.......91.....81.....71...._81 CD.......62.....52.....42..._52 EF.......33.....23.....13..._23 Avg.._62...._52...._42 So in pivot table, is there a way to put show detail for EVERY cell? Or is there another quick/easy way to create a table like the above? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I show full detail of merged items in a pivot table? | Excel Discussion (Misc queries) | |||
pivot table, show detail for multiple cells | Excel Discussion (Misc queries) | |||
Pivot Table - Disable the Show/Hide Detail upon refresh | Excel Discussion (Misc queries) | |||
Formatting Pivot Table- when doble clicking to show Detail | Excel Discussion (Misc queries) | |||
show detail in pivot table | Excel Discussion (Misc queries) |