Is it possible to not show any value on total for certain metrics? .I am not using table calculation.

Suppose, I have to schedule a dashboard report (export to excel/csv/pdf and email) to county, region and area manager. How to send the report to all manager, but the manager will only be able to view report according to their responsibility. Like are...