Description
Currently, you can create subitems and have columns that ask for a count on each line and you can see totals if you link to main record for all of the subitems under that record as a total. However, when i download xls report, it lists all of the numbers from the subitems with commas and does not sum them up on spreadsheet automatically. For example, my subitems are locations. Each location has a subitem line item under the deal with a number of shipments. When i download the xls. it will show 12, 3, 5, 3, 9 and not show 32 as the answer. Because of that, I have to reformat the spreadsheet every time to add those numbers up.
What are you trying to achieve
I want to be able to see the sum of subitems and not have each number broken down and separated by commas on xls report i download