Seriously missing some PowerPivot concept...

mdrew9

Board Regular
Joined
Mar 4, 2006
Messages
118
I cannot get this to work. I have a source table which is a dump from a clients SAP system. On a simple level lets just say it has

tblSAP(Project Number, Account Numbers, Dates, Month(#), Year and Charges)

I have created other tables which have more data for grouping and reporting

tblDateGrouping (Month, Quarter, Month Name)

tblProjects (Project Number, Project Name, Project Type)

tblDescription (Account Number, Account Description (ie, Real Estate, or Operations)

I create relationships between tblSAP AccountNumber, Month#, Year to the other tables. But I do not add columns as =related() in tblSAP.

Now I want to create a pivot table that is built like tblProjects(Project Name), tblDescription(Account Description), tblSAP(Charges) by tblDateGrouping (Month Name)

This does not work. I can tell it doesn't work because when I create this pivot and I put tblProjects(Project Number) and tblSAP(Project Number) I get many tblSAP(Project Numbers) for each tblProjects(Project Number), where project 1001 should only = 1001.

The only way I can get this to work is by adding =related() columns for each "vlookup". But doesn't this defeat the purpose???? What am I missing???
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
by default, if you place only data in your pivot table 'row labels' you would get *ALL* possible combinations. As Laurent stated, placing a numeric value in the 'values' section will generate an effect in which the pivot table automatically filters out all the other combinations for which there is no data. As such, is always a good practice to place values first and then row labels later.
 
Upvote 0

Forum statistics

Threads
1,226,695
Messages
6,192,481
Members
453,727
Latest member
tuong_ng89

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