Create a simple table for dashboarding

Hi

What's the easiest way to create a very simple table which contains a summary of data from a grid which collects survey responses for dashboarding

I want to be able to create a summary by "Account" with a count of various statuses [see example below]

Account Open Closed

Apple COUNT Account = Apple & Status = Open COUNT Account = Apple & Status = Open

Beta COUNT Account = Beta & Status = Open COUNT Account = Beta & Status = Open

And so on for each account

Thanks

Dan

Tags:

Answers