5

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?

3
  • 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, 2013 at 20:05
  • It is a bit clunky but this can work: Displaying Text Values in Pivot Tables without VBA
    – zx8754
    Jun 24, 2013 at 22:13
  • I tried both, neither options satisfied the user story I have to satisfy. Thanks for your help. Sep 13, 2013 at 17:17

1 Answer 1

2

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.

1
  • 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. Sep 13, 2013 at 17:17

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .