I have placed two Excels on one dashboard-tab with the following identical fields: [year], [sex], [total] and different fields as items (x-axis): [diversity] and [function]. I want to link the two Excels with one data player on the field [year] of - for example - the first Excel. In some tabs the different Excels change there info with the data player of one Excel but not here. What do I have to do so that this works fine? :-[
Here an exemple.
Quote from: so10070 on 11 Apr 2020 03:45:47 AM
I have placed two Excels on one dashboard-tab with the following identical fields: [year], [sex], [total] and different fields as items (x-axis): [diversity] and [function]. I want to link the two Excels with one data player on the field [year] of - for example - the first Excel. In some tabs the different Excels change there info with the data player of one Excel but not here. What do I have to do so that this works fine? :-[
Hi,
Your best bet would be to bring both uploaded files into a data module and join them in the data module. Then base your dashboard on the data module.
Cheers!
MF.
Ok, it works! Thanks! :D