Turnover Groups

Question

Good afternoon Community,&nbsp;&nbsp;I have a connundrum that I wanted some help with 🙂&nbsp;&nbsp;I have a simple list of turnover by account 2022.&nbsp; What I would like to do is&nbsp; create a measure that sums the total turnover by account and give them a category based on total turnover as follows:Group 1 'Std' - &lt;£5kGroup 2 'Progressive' - &gt;£5k &lt;£25kGroup 3 'Target' - &gt;£25k &lt;£50kGroup 4 'Allaince' - &gt;£50k &lt;£150kGroup 5 'Prime' - &gt;£150k&nbsp;&nbsp;My aim is to then put this data in a map using the above data as the legend:&nbsp;&nbsp;Any ideas here wouyld be greatly appriciated 🙂&nbsp;

saravanan_p · Answer

Hi,Its straight forward.First create buckets in calculated column to capture category by using nested if. There you get group 1,2,3, etc according to your needs.Now drag and drop turnover in values and maps with location and legends as this calculated column.Hope its clear and kindly mark it as solution&nbsp;&nbsp;

msbiuser1 · Answer

That awesome. So speedy. I was about to type the same. Congratz.ajaydavidluke&nbsp; Kindly mark it as solution , keeps the community healthy

saravanan_p · Answer

Hi,Thats perfect. And your results are correct. I see different color in maps. Check deeply, you see legends with different colors, but data is more for blue. You can obserev 1 or 2 orange color spots too. So its working.&nbsp;Kindly mark as solution , as this would support our community.&nbsp;

ajaydavidluke · Answer

Thank you for the response, please correct me where I am wrong, I'm new to this functionality, your help is greatly appriciated 🙂 from the below I am not getting the desired result!