I want to group the below table as below, I have a column we’re numbers are in all series, I want to segregate 100 series separately and 400 series separately and get the count kindly advise on the query
num1 Count of 100series Count of 400ser
100 100 400
123 123 402
400
402
Hi @aaa2324,
one question: the above table is done using a search or they are the waw data?
if it's the result of a search, please share it.
Ciao.
Giuseppe
Hi Team, these are fetched from raw data