Need some help with filtering

[Claudiu159]

What would be the best approach to find out the average quantity of items ordered in each city on a monthly basis?

I don't know where to start from.

The output should be like this : 

[JamesCharnley]

Hi @Claudiu159,

It's hard to know for sure without your inputs, but from the output picture it looks like that'll be a summarise tool, grouping by month and then choosing average for the relevant cities.

[mceleavey]

Hi @Claudiu159 ,

can you please provide some data representative of your workflow and what you're trying to show?

M.

[Claudiu159]

my data looks like this

and what im trying to show is in the post

[Emmanuel_G]

@Claudiu159 

Find attached the way of doing this easily with Crosstab tool.

According to your input, you just have to select the dates in Group Data, city or countries as column headers and Quantity in values ​​by selecting average.

Let me know if there is any issue.

Do not hesitate to mark this answer as solution if it helped.

[Emmanuel_G · Accepted solution]

@Claudiu159 

Updated version

Let me know if there is any issue. 😉