Oct 27 2021 10:24 AM
Oct 27 2021 10:36 AM
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.
Oct 27 2021 10:49 AM
Oct 28 2021 03:00 PM
SolutionIf using formulas please check as variant in attached.
Oct 28 2021 03:00 PM
Solution