Summarize and Count

[Feras95p]

Dear all,

As you can see from the sample file attached, I want to have in the output the data of period from 1/8/2021 to 31/8/2021 how many Eastern, Western, Low-fat, Keto and Bukhari of Package premium and the same for package Express. Also, I want to have the sum of prices of the same period from 1/8/2021 to 31/8/2021.

Thanks in advance for your kind support. 

[Qiu · Accepted solution]

@Feras95p 
I was not fully able to understand the question and hope this is something you can start with. 😁

[Feras95p]

@Qiu  Thanks for helping! 

I have one more question, as you can see in the picture below, I don't know why the summarize tool doesn't do the sum for the "عدد الوجبات" Even though as you can see in the output record number 2 and 3 has the same columns of group by but the values of  "عدد الوجبات" are not summed !  

 

[Feras95p]

I have solved the issue, thanks