crosstable report

Sanoman

New member
Local time
Today, 23:04
Joined
Nov 25, 2003
Messages
9
Well, I have a table with the following fields:

B# | L# | cost

Where B# is a big unit, L# is a subunit and "cost" is its cost :)
What I need is a big overview with ALL B#'s listed on the very left side. And above should be listed all L#'s and the cross of both gives the costs. Like this:

-----L#---L#---L#---L#
B# cost cost cost cost |||SUM(COST) "-> the cost of one B"
B# cost cost cost cost |||SUM(COST)
B# cost cost cost cost |||SUM(COST)
B# cost cost cost cost |||SUM(COST)
--- costs of all B#'s --------->SUM(SUM(COST))

I couldnt find a suitable Wizard solution, so youre my last hope! :D

Thanks!
-Michael
 

Users who are viewing this thread

Back
Top Bottom