Forum Discussion
Difficult in BI || Analyzing Geocodes based data
I have two tables: Table 1 with outlet codes, names, geo codes, and sales; Table 2 with HCP codes and geo codes. When I choose an HCP, I am trying to get outlet wise sales data from nearby (approximate 1 kilometer radius) outlets (as per geo codes) for that HCP.
1 Reply
Hello amksingh ,
You should have a relationship between these two tables inorder to read the sales with respect to HCP.
If I answered your question, please mark my post as solution, Appreciate your Kudos đź‘Ť
Follow me on Linkedin
Vote For my Ideađź’ˇ
