Sub totals in straight table

[Pujitha]

Hello

Can we achieve some like this in straight table: Exactly same requirement I need.Please see the attached.Please help me

[sergio0592]

Hi,

Hi, yes you can. You have to load a dim table with :

Dim:
LOAD * INLINE [
    Dim
    1
    2
];

And use it in the chart dimension. See the attached .qvw file.

[adamgaox]

Another way would be pre-aggregate the data in the table.