Summary values when grouping data

[clickertape]

how do i get summary values shown in a table?

i.e.

i want to show information for a range or customer order numbers, each of which has more than one line.

i want to see...

order no - part no - qty - price - value

1               1            1       2.0     2.0

1               2            2       3.0     6.0

summary 8.0

2               1             1      2.0     2.0

summary 2.0

etc.

is this possible?

[Digvijay_Singh]

You can use Partial Sum in pivot table to have sub totals, please elaborate in which chart you are trying this?

[qv_testing]

PFA,

[shiveshsingh]

Put one expression as summary

aggr(sum(value),[order no])