Forum Discussion

ajaydavidluke's avatar
ajaydavidluke
Icon for Helper I rankHelper I
3 years ago

Turnover Groups

Good afternoon Community,    I have a connundrum that I wanted some help with 🙂    I have a simple list of turnover by account 2022.  What I would like to do is  create a measure that sums the t...
saravanan_p's avatar
saravanan_p
Icon for Resolver III rankResolver III
3 years ago

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 

 

msbiuser1's avatar
msbiuser1
Icon for Advocate I rankAdvocate I
3 years ago

That awesome. So speedy. I was about to type the same. Congratz.

ajaydavidluke  Kindly mark it as solution , keeps the community healthy