Thread: Summary
View Single Post
  #1   Report Post  
 
Posts: n/a
Default Summary

Is there an option to summarize a certain column of information e.g

Here is an downgraded example of a table I have:

IDNo CompName Description TotNoTX TotTxAmount
1234 ABC Warehouse Hammer 200 1542.40
1234 ABC Warehouse Spanner 50 445.00
1234 ABC Warehouse Nails 1000 946.50
ABC Warehouse Total 1250 2933.90(SubTotal)
2468 XYZ Wallmart Spanner 95 845.00
2468 XYZ Wallmart Screwdriver 65 640.80
2468 XYZ Wallmart Wrench 25 325.60
XYZ Wallmart Total 185 1811.40(SubTotal)
Grand Total 1435 4745.30

What I want here, below the Grand Total, is a summary of the
Description column e.g

1 Hammer 200 1542.40
2 Spanner 145 1290.00
1 Nails 1000 946.50
1 Wrench 25 325.60
1370 4104.50

Is this possible and how?

JK