Total in colums and send email

[16655008]

 hi !! can someone help me? i need to send a email dayli, a greed whit total sales in determinate date, how i  can  get a total for each colums, and send in the email ? . 

[Greg_F]

One possible option would be to create  a table called Totals, and have there  a row that would sum up all items you want. This means:

• create link in the Totals table to table on your image.
• Link to all items that should be in the summary
• Add a Rollup column Total 1 that Totals table using SUM formula inside rollup 
• do the same for Total 2
• Send out email using data from Totals table.