Resolved: What is the aim of building the column "CountryOrder"?
As we will see later in Task Four, Part 3 (06:18 - 06:54), we are sorting the bar chart visual by SalesTerritoryCountry. No need of the column CountryOrder.
Additionally, the CountryOrder column complicates the calculation of the %TotalSalesAmount : there we need to apply an ALL-Filter (Task Four, Part 3, 03:33).
What is the aim of building the column CountryOrder?
Additionally, the CountryOrder column complicates the calculation of the %TotalSalesAmount : there we need to apply an ALL-Filter (Task Four, Part 3, 03:33).
What is the aim of building the column CountryOrder?
1 answers ( 1 marked as helpful)
The idea behind country order is to be able to order countries in the order you want them to be. Sometimes you may be required to order them in a specific order that is not ascending/descending.