Why after applying filter on a report, Workspace show site wise total whereas Reports and Analytics show filtered data in Totals
The reason workspace and reports & analytics shows different data for total as they both works on differently.
Applying a filter to R&A report shows the total for the returned line items. Whereas, workspace will show the site wise total as it includes all the rows in total.
In workspace total work as a static row, so if end user want to see the total of the returned line items or couple of line items then can select the rows for which user want's to see the total, right click on them and select option "Display Only Selected Rows". The total for selected line item will be displayed