Multi-tiered "group-by" list report

[ChadLee4]

Is there a way to have a multi-tiered group-by in a list report?

For example, am I able to group a table by state and then group by city within that state?

[Hemanth M1]

Hi @ChadLee4 ,

We will not be able group by multiple columns in a list report , However you can something similar by using "Functional Fields"

1)Create a logic to Concatenate State and City

2)Group by that field

Below example show concatenating Category and Subcategory and group by that field 

Accept and hit helpful if it resolves.

Thank you,

Hemanth

[ChadLee4]

Thank you for the workaround! Is there a way to do it outside of list reports?

[Hemanth M1]

Yes, create bar chat instead list type and add group by and additional group by

Below the bar graph select group by state and stack by region

[Hemanth M1]

Hi @ChadLee4 ,

did it the above solution work?