Power Pivot guidance - data structure and avoiding many-many relationships

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
3,231
;you need re-define relationship from Register to Survey_Conversion1, (I added new tables: Survey Conversion1 and Outcome_Themes1)
see relationships in DataModel (re-download file from post#7)
 
Last edited:

gwoolley0302

New Member
Joined
May 13, 2014
Messages
48
Hello,

I have re downloaded the file from post 7, and looked at the new tables you've put in. But I don't understand them unfortunately. And I'm not sure whether they are the crux of the problem, which I *think* is successfully assigning 'technical sub categories' to their 'technical area' "parent" (as shown in the potential tables of results in my previous post #8 ). Which, in turn will allow results grouped by the 4 "technical areas" (e.g. 1. engagement/enjoyment, 2. accuracy, 3. fluency, 4. comprehension).

Any further thoughts? (Sorry for consuming lots of your time!)
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
3,231
see pivot table sheet and choose appropriate columns to add: example

btw. see text in white frame at the bottom of the post :)
 

gwoolley0302

New Member
Joined
May 13, 2014
Messages
48
Unfortunately still isn't what I need. But I completely understand that's because I'm not sharing the right info with you !! I've added some notes into the 'Pivots sheet' next to your suggested pivot. Does this help explain what i'm looking to do...?
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
3,231
I've added some notes into the 'Pivots sheet' next to your suggested pivot. Does this help explain what i'm looking to do...?
Honestly? No, because I don't see "some notes" :LOL:

===
you need to convert (if necessary) all tables to 1NF
then create proper relationships
then create PivotTable as you want
 
Last edited:

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
3,231
I resolved the first problem - relationships
I did two tables into 1NF
I did relationships with the rest of the tables
I did example PT (if it is wrong you can create your own)

the rest it's up-to-you

Have a nice day
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
3,231
You cannot group subcategory you show because there is more subcategories which are not duplicated, you can filter it if you want

 

Forum statistics

Threads
1,077,895
Messages
5,337,054
Members
399,120
Latest member
Sravankumar

Some videos you may like

This Week's Hot Topics

Top