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

1 Workbook with 10 tabs but with only 1 query

19 Views

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