I have read many posts from different sites and want to make sure I am understanding the limitations (IMHO) of PowerPivots
What I want to do - I do quite easily in both Access and Crystal Reports but thought I would see how PowerPivot works
I have 2 separate excel files
1 files has a list of students with their home addresses and includes their student ID # (Unique) = Contact File
NAME/Address/Student ID
other file is same list of students/their student IDS/and a Absent field indicating how many times they have been absent= Absent file
NAME/Student ID/Total Absents
The end report should be a list of students /with their address/total absents = 3 columns
NAME/Address/Total Absent
In Access and crystal I simply link the student iID fields and run the report- works every time
PowerPivot no combination of links seems to work, given the lookup relationship and the absent field valculated - you guessed it the total for all students not the row record
I read that I can create a DAX calculation but no way my users are going for that I much rather take it back to access or crystal
So am I to understand that linking the tables in PowePivot is not really linking like in Access but , yes an easier vlookup, and really does not join the data on the unique field
Many Thanks
What I want to do - I do quite easily in both Access and Crystal Reports but thought I would see how PowerPivot works
I have 2 separate excel files
1 files has a list of students with their home addresses and includes their student ID # (Unique) = Contact File
NAME/Address/Student ID
other file is same list of students/their student IDS/and a Absent field indicating how many times they have been absent= Absent file
NAME/Student ID/Total Absents
The end report should be a list of students /with their address/total absents = 3 columns
NAME/Address/Total Absent
In Access and crystal I simply link the student iID fields and run the report- works every time
PowerPivot no combination of links seems to work, given the lookup relationship and the absent field valculated - you guessed it the total for all students not the row record
I read that I can create a DAX calculation but no way my users are going for that I much rather take it back to access or crystal
So am I to understand that linking the tables in PowePivot is not really linking like in Access but , yes an easier vlookup, and really does not join the data on the unique field
Many Thanks