Changes between Version 1 and Version 2 of Ticket #11305, comment 12
- Timestamp:
- Sep 8, 2011, 7:27:56 PM (13 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #11305, comment 12
v1 v2 1 1 I need the equivalent of sumifs (http://office.microsoft.com/en-us/excel-help/sumifs-function-HA010047504.aspx?CTT=3) and countifs (http://office.microsoft.com/en-us/excel-help/countifs-function-HA010047494.aspx) to replace a report that is currently baked into an excel spreadsheet somewhere. 2 2 3 In a nutshell, we have orders which have a quantity of items, a total amount for the order, tax amount, and are related to a specific customer name. I need to output something like this:[[BR]]3 Over-simplified, we have orders which have a quantity of items, a total amount for the order, tax amount, and are related to a specific customer name. I need to output something like this:[[BR]] 4 4 Customer, Total Items (per customer), Total Orders (per customer), Total Amount (per customer), Total Tax (per customer)[[BR]] 5 5 UserA,6,3,$50,$5[[BR]]