I have used the latest Report script discussed in this thread which I downloaded here
Report - MQL4 Code Base
and the created an Excel macro which takes the report produced by the script and groups and subtotals trades based on EA and within in by currency pair and adds pips totals.
The macro creates 2 additional columns in the report before applying sort and subtotal commands. First one is pips to see trade results and totals by pips. Second column is "System" which is populated with each EA name based on the comment (comment field needs to be exported in the original Report script)
A little bit of programming knowledge is required to get it to operate for you (update the EA naming function with your own EA names, change the report sheet name referenced to your report sheet name).
After the macro is set up and saved which you will only need to do once, from then on just open the .htm report generated by the Report script in Excel and run Macro to get all your totals and subtotals. Please note open the actual htm report in excel, do NOT copy and paste the transactions from the report into Excel as this will most likely mess up cell references.
I hope someone would find it useful.
And if someone knows of a software or service that allows one to see states by EA from a single live account I would appreciate if you can let me know.