Grouping data in the straight chart

[#1]

Hi,

Please find the attached xls and qvw files. Please help how can I group the data based on area.

( I don't want to use Pivot table)

Supportability	All asset documents updated but not uploaded
	System Portal up-to-date.
Risks/Security	All STP standards are met

[#2]

I can do it in pivot table if I check "always fully expandable" but i want to do it in the staright table

[Clever_Anjos · Accepted solution]

Please, go to Dimensions Limits tab

Select 2nd dimension and check "show total"

[#4]

Is it possible in table box?

[Clever_Anjos]

No, a table box is a very simple object.

It doesn´t allow aggregations, etc