Categorize sales data

Ask the Community
#1

How can I categorize sales data into different performance tiers based on revenue levels?

#2

Use the SWITCH() function to assign each revenue level to a specific tier

SWITCH({Revenue},
{Revenue} < 10000, "Low",
{Revenue} < 50000, "Medium",
{Revenue} < 100000, "High",
"Very High")
1 Like