Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hello all,
I have the following data sources:
Table 1: contains sales and profits by month/year/company/department/cost center.
Table 2: contains the number of employees by month/year/company/department/productive indicator.
I would like to calculate key figures based on these two tables (e.g. sales per employee).
For this I need slicers that allow me to filter month/year/company/department in both tables 1 and 2 at the same time.
Which possibility do I have here? Unfortunately, it is not possible to link the two tables 1 and 2.
Thanks a lot for your help!
What do you mean with 4 Dimension table?
month/year/company/department Should be 4 dimension tables each linked to both main tables
Can you at least create the 4 dimension tables and link them to both tables?
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
19 | |
14 | |
8 | |
7 |