Brand specific sales analysis

We are distributor for various brands at the end of year this brands launches some incentive program so to analyse this we have to manually select bill go in detail and maintain it in excel don’t we have a feature in swipe where we will select customer and brand/vendor name and it will get a report ?