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!