Skip to Content
0
Former Member
Jan 11, 2008 at 05:49 PM

selections on query designer

32 Views

Hello gurus,

I have a question about query designer.

I have various selections (cost centre) on structure. And i want under each selection the detail os costs for each cost centre.

i have:

structure:

selection 1 (cc = 1100001)

selection 2 (cc = 1100010, 1101101, 1100002)

and i want the result to be:

selection 1 10000

1100001 10000

selection 2 5000

1100010 1000

1101101 2000

1100002 3000

i tryed to put char cost centre below my structure, but it show me all cc's below each selection.

How could i do this?

Thanks in advance.

Vitor