J
Jim Coughlin
I have a cross tab query that I want to turn into a report with a specific
cascading set of subtotals, and I can't figure out how to do it.
The query result looks like this:
Site, Job, WBS, Budget Type, Cost Element, Value.
Site, Job, WBS, & Budget Type are Row Headings, Cost Element is a Column
Heading, and Value is of cours the Value.
What I want to do is create a sub-total for each of the two Budget Types at
the WBS level, Job level, and Site level. So I have two separate subtotals in
each group footer. I am stumped on how to accomplish that.
cascading set of subtotals, and I can't figure out how to do it.
The query result looks like this:
Site, Job, WBS, Budget Type, Cost Element, Value.
Site, Job, WBS, & Budget Type are Row Headings, Cost Element is a Column
Heading, and Value is of cours the Value.
What I want to do is create a sub-total for each of the two Budget Types at
the WBS level, Job level, and Site level. So I have two separate subtotals in
each group footer. I am stumped on how to accomplish that.