| ScenarioDateID | Portfolio | Total |
| 20160701 | A AUD OPT AU | - 337,065 |
| 20160701 | A CAD OPT AU | - 229 |
| 20160701 | A CPI OPT AU | - 17,770 |
| 20160701 | A CPI OPT2 AU | 13,322 |
| 20160701 Total | | - 341,742 |
| 20160704 | A AUD OPT AU | 1,238,323 |
| 20160704 | A CAD OPT AU | 33 |
| 20160704 | A CPI OPT AU | 378,288 |
| 20160704 | A CPI OPT2 AU | - 98,216 |
| 20160704 Total | | 1,518,428 |
| 20160705 | A AUD OPT AU | - 130,404 |
| 20160705 | A CAD OPT AU | 1,625 |
| 20160705 | A CPI OPT AU | 56,491 |
| 20160705 | A CPI OPT2 AU | - 150,693 |
| 20160705 Total | | - 222,981 |
| 20160706 | A AUD OPT AU | - 529,386 |
| 20160706 | A CAD OPT AU | 1,113 |
| 20160706 | A CPI OPT AU | - 4,093 |
| 20160706 | A CPI OPT2 AU | 14,396 |
| 20160706 Total | | - 517,970 |
I have 4 dates, and each date has 4 portfolios, I need to total them by each date and out of that 4 dates total, I need to get 2nd lowest which is 341,712.
Kindly Help.
