Hi, i need to know if there is a solution to a case like this:
I've a workbook with 10 tabs, in each tab i have inserted a query with the only difference being different Cost Centers, but the Key Figures are the same. So, basically it's like this
CoCe 1 - Quantity 30
CoCe 2 - Quantity 45
There are 10 copies of the same query with changed Cost Centers.
The Question is, is there a option to make it as only one query but with different Cost Centers in each tabs?
I tried to do it with Query Variants, but i cannot insert them in a workbook. Only queries can be inserted in each Tab and not variants!!