Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Here is my use-case.

As a training specialist I want to look at a single tab in Excel and see student feedback at a glance. I want to see pie-charts showing who said "Yes" this course was a good use of my time and "No" this was not a good use of my time. Under each pie chart I want to see the list of comments for "Yes" and for "No". I want filtering for just my classes or for a specific class offering to be easy.

So I have a RawData data table with all my survey data on it's own tab. On my ResultsTables tab you have a set of pivot tables that correspond to each question (I only listed one question in my use-case to make it brief). On the Dashboard tab I have the pie charts laid out and slicers to make filtering easy.

Here is where I get stuck. I can't seem to force Pivot Tables to show the survey comments in a separate pivot table under the pie chart with a filter for "Yes" or "No" to help parse the comments based on their context. The comments are text-strings (e.g., You gve the most awsome class evr!)

Is there a way to force Excel 2010 to make it's pivot tables display the actual values of cells in your RawData while filtering for a specific subset?

share|improve this question

migrated from stackoverflow.com Jun 25 '13 at 7:46

This question came from our site for professional and enthusiast programmers.

1  
Is there a way to force Excel 2010 to make it's pivot tables display the actual values of cells in your RawData while filtering for a specific subset?... Double click on the value.. new sheet with raw data making up that value. –  xQbert Jun 24 '13 at 20:05
    
It is a bit clunky but this can work: Displaying Text Values in Pivot Tables without VBA –  zx8754 Jun 24 '13 at 22:13
    
I tried both, neither options satisfied the user story I have to satisfy. Thanks for your help. –  Kevin Taylor Sep 13 '13 at 17:17
add comment

1 Answer

Have you tried not putting your Comments field in the Value section but on the Row Label section, and displaying your pivot in tabular form?

As long as you are setting your filters correctly, only the comments for the courses you are interested in would display, and every time you refresh the data on one of your pivots, if they are copies of each other, they will all refresh at the same time.

share|improve this answer
    
Yes, that would work...kind of...I tried it using random variations of lorem ipsum for test purposes and it only displayed a small sub-set. –  Kevin Taylor Sep 13 '13 at 17:17
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.