expand and collapse button with subtotals
 

I would like to insert a expand and collpse button to my data in rows.
data:-
a---------b---------c---------d-----------e------
date----item-------rate------qty--------value
01/05--mangoes--2.50---1000-------2500
02/05--apples-----5.50---2000-------11000
02/05---mangoes-2.00---1000------2000
03/05--apples-----4.00---1000------40000
grouping required by item.I tried datagroup but subtotals are not reflecting.

expand and collapse button with subtotals
 

If you want to group by item, then sort your data by item.

Then use Data|subtotal to subtotal by item.

TUNGANA KURMA RAJU wrote:

I would like to insert a expand and collpse button to my data in rows.
data:-
a---------b---------c---------d-----------e------
date----item-------rate------qty--------value
01/05--mangoes--2.50---1000-------2500
02/05--apples-----5.50---2000-------11000
02/05---mangoes-2.00---1000------2000
03/05--apples-----4.00---1000------40000
grouping required by item.I tried datagroup but subtotals are not reflecting.

--

Dave Peterson