Multipal Filters in Single Report

[Atif]

Hi

I have data in following columns:

Sales Manager Project Status
aaa Proj1 100%
bbb Proj1 100%
aaa Proj2 90%
bbb Proj2 100%
bbb Proj3 90%
aaa Proj3 90%

I want to generate a report/chart to display data group by each "Sales
Manager" and count of "Status" i.e. aaa has 1 (100%) 2 (90%), bbb has 2(100%)
and 1(90%).

How can I show this data in single Report, keep in mind data is not static
it keeps changing and increased in number by time.

Thanks

 

[Duane Hookom]

I don't know what the subject of your message has to do with your question or
if you want a report or a chart on a report.

You should be able to create a report based on the following SQL.

SELECT SalesManager, Status, Count(Project) As NumOf
FROM [In the following Columns]
GROUP BY SalesManager, Status;