Forum Discussion
Organizing survey data into one pivo
.png){kind=link}
This is wonderful!
A couple questions:
1. I decided I will separate the prelim questions into pivot tables on separate tabs. i.e. one for marital status, retirement timeline, age bracket. When I went to create a pivot table from power pivot for another prelim question I noticed in the field list I did not have the option for fxResponses under Table 1 to add to the Values box. There's now an option showing fxAnswer% Could you explain why? Screenshots attached.
2. This analysis is something that gets looked at every 6 months or so, when more respondents have taken the assessment. If I wanted to update the raw data, would I just paste that into the Data tab and refresh the pivot tables?
Thank you so much!
.png){kind=link}
#1 IF I understand your point that doesn't matter. Actually the Power Pivot Measure is named Answer%:
When you create a new PivotTable from the Data Model you therefore get the above Measure names
Put the Answer% measure in the Values area of your PivotTable. The new column will be auto. named Answer%. Click on the column header and rename it as you want, i.e. Responses
#2 YES, add your new records at the bottom* of the Table in the Data tab > Refresh your PivotTables
* 1st available row after the bottom of the existing Table
- Right before you responded I realized you had just renamed the field, makes sense!
I think that covers what I needed. Thank you again!!- You're welcome. At the bottom of each post you get here there's a Mark as answer link. Clicking it helps people who Search for existing solutions - Thanks