Can you attach the workbook in 10.5 version?
Hope you are doing good.
Just checking, if you can attach the workbook in 10.5?
I am using 10.5; looks like you have attached in a later version, which I am unable to open
1 of 1 people found this helpful
Adding a column no was a brilliant idea.
Since by data is in SQL server, I created the below calc to generate column no (The countries available in my data are little different)
if LEFT([Country],1)>="A" AND LEFT([Country],1) <="C" THEN 1
ELSEIF LEFT([Country],1)>="D" AND LEFT([Country],1) <="J" THEN 2
ELSEIF LEFT([Country],1)>="K" AND LEFT([Country],2) <="RO" THEN 3
ELSEIF LEFT([Country],2)>="RU" AND LEFT([Country],1) <="T" THEN 4
The above calc gives the below output; this is working great.
Only challenge would be to re-distribute the countries, when a new country is added to the data (for eg, I don't have Ecuador in the data now), so that all columns have the same no of countries. Anyhow, this is not a big concern for me now.
Thanks a lot for your help