I have the following table:
A few of pointers:
1. Look at the EMEA region. I have sorted on "Impressions" and yet Egypt, which has a value of 11 is placed below Russia, which has value of 9. This is my major concern and want to fix it. I want to display the right order i.e. the App, date, region will be fixed whereas only order of country will change.
Also, I am facing the same problem when sorting on the other measures present in the view.
Could it because I am blending data sources?
2. Look at the "Rows" panel, "Region" & "Country Name" are from my secondary data source whereas "Country" is primary data source (it is hidden in the view). If I move Country to the right of "Country Name", I no longer have the sorting option as it is grayed out. What could be the reason for this?
Any sort of help is appreciated.
Please post your workbook so I could take a look.
In any case, some sorting capabilities are disabled when data sources are blended.