Report Bookmark for export and subscription

Hi,

I was refering to Ibendlin answer; I believe export to file requires Premium subscription?

Your solutions does not really work for me. I do not wish to restrict data access. What I would want is to distribute reports based on selections/favorite. 

In my example, the dashboard - contains data for all stores

I want Director of store A to have access to all the data, but be able to receive a report with his own store performance.

It seems there is no way to do this without creating one duplicated reports or sheets with individual fiters