I just installed PowerPivot, and am learning by going through the book 'PowerPivot For the Data Analyst'. I've really enjoyed the book, but I appear to missing some simple point. I have three tables. Each of the three tables have an ID. It's the same ID in all three tables. Table one contains billing for each ID. Table two contains merchant counts for each ID. Table three contains transaction counts for each ID. Using the Create Relationship option, I related Table one to Table two using ID, and then related Table two to Table three, also using the ID. However, when I build a pivot with ID for the Row, and then Billing, Merchants, and Transactions as the calculated columns, I get Billing correctly, but Merchants and Transactions are not. I receive the message that a Relationship needs to be created (although I thought I already had above), so I choose Create, but a relationship is not found. Please help me understand what step I'm missing.
Thanks!
Thanks!