Combining multiple groups into few groups
Hi Guys, I wanted to combine data and group these 12 categories into 4 categories. How can i group together data, so that my report shows only 4 category colors instead of 12
Forum Discussion
Create a formula-text field and use a case formula to 'categorize' your importance.
Call the field [Importance]
>
use this formula structure (some of the names or fields may need to change based on your naming)
>
Call the field [Importance]
>
use this formula structure (some of the names or fields may need to change based on your naming)
>
Case([Category Field],
"B", "Very Important",
"Hotels", "Very Important",
"International", "Very Important",
"IR", "Important",
"Meals", "Important",
"P", "Important",
"C", "Normal",
"Direct", "Normal",
"Running", "Normal",
"Contract", "Can Be Delayed",
"Strategy", "Can Be Delayed",
"P", "Can Be Delayed",
"")