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