Power Pivot link issue

[atuljadhavnetafim]

Hi,

i have two table in Power Pivot, both the table don't have any duplicate value.
First Table MSME column "Reference Number" link with another table Category which has category column.
in Category Table also has unique item which categorized in three "Dealer", "PO Based" and "Warehouse"

when we generate pivot table it show me 3 values against each "Reference Number" but each Reference number has only one category defined in Category table.
i don't understand why they show all category against all Reference number,

can any one help.

 

[atuljadhavnetafim]

any help on this

 

[RoryA]

You need to add a value field to your pivot table.

 

[jdellasala]

Your statement "both the tables[sic] don't have any duplicate value" cannot be correct. According to the picture of the Pivot Table, the MSME table may have unique values in the Reference Number field, the Account field in the Category table obviously has multiple values, specifically the Account 406531 appears three times in the Category table's Category field - Dealer, PO Based, and Warehouse.
Also it's confusing to name a table the same as a field and just makes things that much more difficult. Perhaps one of them could be called Categories so they could be distinguished?

 

[atuljadhavnetafim]

in both the table, there is no duplicate values, i checked many time before i post here,

 

[Alex Blakenburg]

Can you try the steps in this post:
Rory made the same comment there and it has a bit more info

Duplicate Row data in PowerPivot

Hi all, The Pivot Table I created is not producing the desired results. I linked two tables (Table1 & Table2). Table1 contains Customers for Jobs Table2 contains Work Orders for Jobs After adding Table1 and Table2 to the Data Model using Power Pivot toolbar and creating relationships using...

www.mrexcel.com

 

[atuljadhavnetafim]

You need to add a value field to your pivot table.

Yes, after adding value it get resolved. Thanks