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
TAB1:
CoCe 1 - Quantity 30
TAB2
CoCe 2 - Quantity 45
etc..
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!!
Any thoughts??