I have a calculation that summarizes a $ amount at the category level for each person. I'm using this formula { FIXED [Person],[Category]: SUM([$])}
Now I want to group people into different buckets depending on the $ amount for the category total.
So say I choose Animal, I would like to group people into buckets of <20, 20-30, 31-50 etc
Is it possible to do that on a calculated field?
Thanks
Good afternoon
the process for doing that is
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.