BW workbook with multiple Queries:

The second report should get all the A Customers from the first report.
The issue is that I want to do it automatic – meaning that on refresh the first report to read the data
and the second report to read the data from Report 1 (only the A Customers from Report 1)

The end result should be like this: