Pivot table from 2 sources/pivot tables?

[LukasB]

Hi guys,

I have 2 tables of data
1. this contains as columns: unique codes, Device (values = PC/Mobile/Tablet), month, number of orders, Revenue
2. contains unique codes, Device, month, costs

How can I get them together to be able to calculate ROI/Cost per order in every month at the device levels.
Is it possible to connect 2 pivot tables somehow?

Thanks
Lukas

[CK76]

First make sure both are in Excel table format with headers.

Go to data tab and find "Relationships" in data tools.

Use Unique Codes to build relationship and build your pivot table from there.

Alternately, you can leverage MS Query (or PowerQuery if you have it), and merge two table into one and build pivot table from there.