Average delivered and cost

[tatto330]

Hello how to calculate this details from the data set below ?
1. Average delivered order duraton in UA
2. Average delivered order duration in Kyiv
3. Average percentage of cancelled orders (cancelled orders/total orders) for each city
4. Average percentage of cancelled orders in UA
5. Cost per delivered order in UA6. Cost per delivered order in Kyiv

[#2]

@tatto330 ,

You need to specify country and city exactly in the table. Excel has no idea that Odesa is UA and "Kyiv left bank" is Kyiv, sorry for that. With exactly specified country/city you may load data to data model and use DAX measures  to calculate what is required aggregating the result into PivotTable. But first step is proper classification.

[#3]

Hello please see attached document

[#4 · Accepted solution]

@tatto330 

If using formulas please check as variant in attached.

[#5]

Thanks a lot bro