Create Relationships Pivot Table-Stores Table Tab

Vanda_a

Well-known Member
Joined
Oct 29, 2012
Messages
934
Dear all

I am using windows 8.1 excel 2010. And I can't find my Stores Table Tab to create relationships between two datas from different sources.

Somebody brights me up please

My main problem is I wanna join two or three data sources into a pivot table
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Use the keyboard command ALT+D P to open the PT Wizard which allows multiple consolidation ranges (source ranges) for a PT.

This is VBA code for same, but it must be modified to fit your needs. Use the macro recorder to record the above statement for your workbook and edit it as necessary):
Code:
Sub CreatePTFromMultipleDynamicNamedRangs()
    'Create PivotTable from multiple ranges (PT Wizard - Keyboard combo ALT+D P)
    ActiveWorkbook.PivotCaches.Create(SourceType:=xlConsolidation, SourceData:= _
        Array(Array("source1", "Item1"), Array("source2", "Item2")), Version _
        :=xlPivotTableVersion14).CreatePivotTable TableDestination:="", TableName _
        :="PT_" & ActiveSheet.Name, DefaultVersion:=xlPivotTableVersion14
    ActiveSheet.PivotTableWizard TableDestination:=ActiveSheet.Cells(3, 1)
    ActiveSheet.Cells(3, 1).Select
    ActiveSheet.PivotTables(1).DataPivotField.PivotItems( _
        "Count of Value").Position = 1
    ActiveSheet.PivotTables(1).Name = "PT_" & ActiveSheet.Name
        
End Sub
 
Upvote 0
I have tried it but my raw data are not exactly the same header. I got only one column that match each other.

the table can't be customized so it is hard. N I alrdy for found that relationship in powerpivot. Just facing a problem with that add in. An add in cannot be found or cannot be loaded. 3days alrdy looking for solution.

Pls kindly help
 
Upvote 0
All I can think of is import both tables and edit the headers to match. The run the PT from them. I don't know of another way.
 
Upvote 0

Forum statistics

Threads
1,213,535
Messages
6,114,192
Members
448,554
Latest member
Gleisner2

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