Create a KPI from 2 dataset or tables

Q&A
1

HI, I have a problem generating a KPI GMROI or InventoryTurnover
Both KPIs are a little number, but i need data from Sales Dataset and Inventory Cost Dataset.

How can I get a Formula that calculate (for example), sum of Sales / Average Inventory

Sales from Dataset 1
Average Inventory from Dataset 2

Thanks in advanced…

2

Hey Raul,

You would need to join these two datasets into one.

There is no way to take a field from one dataset and reference it in another.

Looking at this calculation, I’m assuming you would want to join on a date field.

You can reference this for joining & join types.