How to summarize data in a table

Get Help
1

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:
image

sharing a sample in the below image on what i am expecting.

summary sample
summary sample793×571 25.2 KB

2

Hi @arunroypeter
You would have to create a Custom Column, which only returns "Call", and then group by that column.
case(substring([source], 0, 4) = "Call", "Call", [source])
Custom expressions in the query builder