• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Regarding Table Relationships in (Normal) Pivot Table

M

MBS

Member
Hi All,
I would like to get more information about how we should put relationship between the tables to get the correct results.
I found that, if sequence of relationship is not correct , the results in pivot table is different. (Wrong) So please explain, what should be first "Table" and what should be "Related Table"

78067
 
Second table is your lookup table. Or in jargon, it's the dimension table. Left table is a fact table. Or also, left is the many side, right is the one side.
Generally speaking (simplified explanation) in the pivot you use field from the dimension table in the filter, row or column sections. Fields to aggregate from the fact in the values section.
 
You must log in or register to reply here.
Back
Top