I created a report from SSRS and did a summary at the detail table header. The operation is use for the grouping and then there's the material sequence that is use for determine what sub component makes up for that fabricated part.
Example fabricated part 123ABC has subcomponent of 399DD and 299FDS that makes up that part. The material and labor from those 2 parts also make up the total cost to make part 123ABC. I am able to get the summary at the header detail level.
However, I also need to do a final summary at the table footer. I can't seem to total up the header detail grouping.
I tried doing the following, but kept stating I can't use it. Can only be use at headers and footers. What can I do so that I can sum up the highlighted in my footer table?
alue, sum, nothing)
TotalSum is the "Total Cost" highlighted in blue. I want all these to sum up at row 12 with total of $6105. However, it kept giving me error.