Hi, Can i use sum and list command in single query

[deepa_purushoth]

For example,
Category | CategoryGroup |Price
AAA|Apple |80
AAA|Apple |90
BBB|Banana|40
BBB|Butterfruit|90

I want to display my data as
Category|CategoryGroup|Total
AAA|Apple|170
BBB|Banana|40
|Butterfuit|90

Please advice.
I tried i can able to get the category and categorygroup in list however i cant do sum, but i can show as count.

[elliotproebstel · Accepted solution]

Yes, you can simply add the stats list() after the sum:

your search| stats sum(Price) AS Total BY Category,CategoryGroup | stats list(CategoryGroup) AS CategoryGroup list(Total) AS Total BY Category

[elliotproebstel]

Hi @deepa_purushothaman - thanks for the upvote! If this solution works for you, will you accept it, so that other users can find it if they have the same question?

[deepa_purushoth]

Thank you elliotproebstel, this is helpful.

[elliotproebstel]

Glad to help!

[deepa_purushoth]

Thank you, but this yields me duplicate value in Category. I want to include list command as well to eliminate show as multiple record under each category.

[HiroshiSatoh]

Try this!

(your search)|stats sum(Price) as Total by Category,CategoryGroup