Now that I am looking at your questions.
1) Why are you working with blending? Have you tried using cross-database joining? This would make your requirement much easier.
Thank you for the reply, but you didn't use measure value from second data source, so blending concept is not applied.
But in my workbook as you can see AP Spend is coming from one data source and SF Spend is coming from secondary data source.
You did sorting to Month of Order Date by right clicking field-sort-Field-spend%. But in my case I cannot select Spend% because that field does not appear in my sort field function.
(AP Spend/SF Spend*100) in my Sort- Field function.
In the below picture in the Field, I don't see Spend% in the list. So I was unable to sort by Spend%
Kindly look my attached workbook once at Sheet6.
My final goal is to sort by Spend% and get top 5 and bottom 5 months.
I did try cross data joins and I am getting error like "unable to materialize temporary table", fields I am using to join both the data sources are of same data types. I am not sure why I am receiving this error.
So I started using data blending here and for some reason I am unable to sort a calculated field which contains data from both primary and secondary data source.