I want to group the report based on company_id.
If company_id equals to 1 or 2 or 3 then the group will be called A
If company_id is not equal to 1 or 2 or 3 then the group will be called B
How do i create a third one which includes entire company_id which might be called C
My code is
if {sl_companies.company_id} in [14788, 32700, 19402] then
"A"
ELSE IF NOT({sl_companies.company_id} in [14788, 32700, 19402]) THEN
"B"
ELSE
"C"
It results me two group A and B. I want to have C as well.
Any help is highly appreciated.
Thanks
If company_id equals to 1 or 2 or 3 then the group will be called A
If company_id is not equal to 1 or 2 or 3 then the group will be called B
How do i create a third one which includes entire company_id which might be called C
My code is
if {sl_companies.company_id} in [14788, 32700, 19402] then
"A"
ELSE IF NOT({sl_companies.company_id} in [14788, 32700, 19402]) THEN
"B"
ELSE
"C"
It results me two group A and B. I want to have C as well.
Any help is highly appreciated.
Thanks