Exporting Forecast Report Subtotals are confusing
This is confusing>>
The duplicated rows is actually the subtotal from the item above it. So in the export you can simply collapse the last hierarchy on the Outlet so that your'e viewing the Account level. You'll see the same numbers now show for the Account. Expand it back out again and you'll see "duplicate" rows. This is because the expansion happens between the Name and the Subtotals and shifts the subtotal to the bottom.