Data to Report Functionality

Hi,

I have a report like

Category Name Salary

A ABC 100

A DEF 100

A GHI 50

B JKL 75

B MNO 80

C PQR 10

Using Data to Report

i want to generate excel file with 3 sheets for A,B & C and the same data getting displayed.

Using filter i have achieved for one category. How can i do for all categories?

Is it possible?

Thanks!