Hi there,
I have a table of demands, and a table of breakdowns. Each demand has multiple breakdown records associated with it (one to many relationship).
Each breakdown contains information on hardware cost, software cost, labour cost, labour hours, and more.
My requirement is to run a report on the sums of these individual components for each demand, see below:
| | Total hardware cost | Total software cost | Total labour cost |
| Demand1 | 4 | 8 | 7 |
| Demand2 | 3 | 5 | 9 |
| Demand3 | 6 | 7 | 1 |
Running the report from the breakdown table, I seem to be able to achieve one of two things:
1) Report type == List: (problem is that there is no total/sum option)
| | Hardware cost | Software cost | Labour cost |
| Demand1 | 2 | 7 | 1 |
| Demand1 | 1 | 0 | 4 |
| Demand1 | 1 | 1 | 2 |
| Demand2 | 1 | 3 | 8 |
2) Report type == Pivot table: (problem is that this can only show total for one column at a time)
| | Hardware cost = 1 | Hardware cost = 2 | Hardware cost = 3 | Total |
| Demand1 | 2 | 2 | 0 | 4 |
| Demand2 | 1 | 2 | 0 | 3 |
| Demand3 | 3 | 0 | 3 | 6 |
Any help with this would be greatly appreciated.
Thank you
Lenka
