Show all requests by category and then by source
Content
Hi,
So the report I need has the columns as the the various types of source and the rows are the different categories
Category | Total Raised | Percentage of Total | Source_1 | Source_2 | Source 3
------------------------------------------------------------------------------------------------------------------
Category 1 | 5 | 25% | 1 | 3 | 2
Category 2 | 15 | 75% | 10 | 2 | 3
Something like that!
I can get the first 3 columns sorted but how would I go about the other columns? I'm not interested in drilldowns or anything like that. I tried doing a count(expr) on the other columns but got nowhere fast
Tagged:
0