Subtotal in Straight table

[keerthika]

Hi All,

How to show subtotal and percentage in straight table ?

a	1
a	2
a	3
Total	6
Percentage	23%
b	1
b	2
b	3
b	4
Total	10
Percentage	38%
c	1
c	2
c	3
c	4
Total	10
Percentage	38%

Can any one say how to show the above data in straight table.

Thanks in advance,

Keke

[jobsonkjoseph]

If i'm not wrong, sub totals can be achieved using pivot table not straight table.

[keerthika]

Hi ,

Is there any way to show in straight table

[jensmunnichs]

You can show the subtotals in a pivot table quite easily, but then you wouldn't be able to see all the individual values. If you want to display all values as well, I think you'll have to use a pivot table and give all your rows some sort of unique identifier (otherwise the data will automatically group).

If you don't want to add an identifier, you can do what I did in the attached file and 'hide' the identifier using the dual() function in script.

EDIT: I forgot to enable subtotals in my attached file, just enable 'show partial sums' for [RealID] in the presentation tab in the properties menu for the pivot table.

[jobsonkjoseph]

Ok, try this,

goto properties> Dimention Limits Tab>

here select the dimension you want subtotal for, down below in "options", check "Show Total" and in label type "subtotal".

this might give you the result you are expecting. Other than this there is no way subtotals can be shown in straight table.

[Frank_Hartmann]

is this what you are looking for?

see attached file.

hope this helps