Grouping/ Pivoting Survey Data

[Natedekock]

Hi BI Community, 

I need your help!
Here is what I am dealing with: 

1. Survey Data

2. 64 questions

3. 8 Categories

4. Each question is part of one of the categories. 

I want to create a decomposition tree where we can break down each category into the relevant questions for the category and show the average scores for that question in that category. 

Difficult to explain but I know there are a lot of smart people on here who can help. 

Thank you in advance! 

[v-shex-msft]

Hi @Natedekock ,

Can you please share some dummy data with similar data structures and expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[PhilipTreacy]

hi @Natedekock 

Have you got any data I can use?

Regards

Phil

[Natedekock]

Hi Phil, 

I can share it with you privately. 

How do I do that? 

[PhilipTreacy]

Hi @Natedekock 

You can send me a Private Message through this forum.

Go to top right of Forum, click on the envelope -> New Message.

Regards

Phil