I am so stuck at "create relationship".
I exported two pivot data tables, and added one excel file. It was working fine. But on the second chart I tried to do, there were several blanks, which indicated new accounts added. So I added the accounts and refresh the pivot table. All cells turned into same value.
I tried to manage the relationship, create the relationship again, delete and add again, delete them all and started from scratch again, it just didn't happen for me again, every time showing "can't create relationship because of duplicated columns", but I created a pivot table for the column only just to verify if there was any duplication, NONE.
What should I do? I could have finished it, now, can't even start!!!!
Please help!
請教powerpivot!多謝!
所有跟帖:
• 不知具體問題是什麽,看點書吧。。。 -slow_quick- ♂ (159 bytes) () 10/20/2012 postreply 09:40:25
• 我剛下載,目前沒時間玩。如有learning curve。。。see youtube 介紹性的講座。。。 -tianfangye- ♂ (37 bytes) () 10/20/2012 postreply 18:29:34