Skip to Content
Former Member
Jun 24, 2008 at 02:02 PM

1 Workbook with 10 tabs but with only 1 query


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!!

Any thoughts??