I'm new to Kendo, but have came across a fairly complex issue. I'm trying to create a view of data, that counts the number of deals made in each quarter. The data is structured as shown in the attached image (see data.png). I've also attached a mockup of the format I want to get this data into (see outcome.png).
What I think it needs to do is count the rows that match a specific 'Customer type' and 'Quarter' and then display this in a new column alongside the customer type.
Is this something that's possible with Kendo? If so, how would I go about making a start on this?