I would want to summarize a table by region & the column is group of count by status of certain sources.
Say in Column 1 there will be region.
in Column 2 i will need a sum of certain lead sources captured by sum of count by lead soruce data.
In column 3 i will need a sum of certain other lead sources.
How can i achieve this.?
Base Data will be like below:
sharing a sample in the below image on what i am expecting.