Create Relationships Pivot Table-Stores Table Tab

[Vanda_a]

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

 

[pbornemeier]

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):

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

 

[Vanda_a]

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

 

[pbornemeier]

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.