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.

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