Rerports Group By

[ChezAndrewI0898]

Use Case:

I have a Donut type report with a source type table. I want to group by a certain field, but the field is not visible from the list. But in the additional group by it is visible.

The field is a list type.

I want the report to be grouped by that certain field.

Please help.

Thanks!

[Dr Atul G- LNG · Accepted solution]

Hi @ChezAndrewI0898 

It is something OOTB and depend on data type which field can be group by or not. As it is list type, how system will do group by on list type, as list type means more than 1 value. 

[Dr Atul G- LNG · Accepted solution]

Hi @ChezAndrewI0898 

It is something OOTB and depend on data type which field can be group by or not. As it is list type, how system will do group by on list type, as list type means more than 1 value. 

[ChezAndrewI0898]

Thanks for this.

However, I was able to make that field on the Additional Group By.

Is there any way making that Additional Group By as default?

[Dr Atul G- LNG · Accepted solution]

Hi @ChezAndrewI0898 

Is there any way making that Additional Group By as default? --> No mate.