Power Pivot link issue

atuljadhavnetafim

Active Member
Joined
Apr 7, 2012
Messages
341
Office Version
  1. 365
Platform
  1. Windows
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.


image
image
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
You need to add a value field to your pivot table.
 
Upvote 0
Solution
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?
 
Upvote 0
Can you try the steps in this post:
Rory made the same comment there and it has a bit more info ;)
 
Upvote 0

Forum statistics

Threads
1,223,911
Messages
6,175,337
Members
452,637
Latest member
Ezio2866

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top