Actually i want to show

1.Total of Am1,Amt2,Amt3 if month changes for particular Manager
2.Total of Amt1,Amt2,Amt3 if manager changes
3.Total no of record of particular month


Manager month serial party Amt1 Amt2 Amt3
---- ----- ----- ------- ---- ---- ----
A jan 1 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10
A jan 2 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10
A jan 3 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10

A jan 3 30 30 30

A feb 1 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10
A feb 2 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10
A feb 3 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10
A feb 4 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10

A feb 4 40 40 40


A mar 1 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10
A mar 2 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10
A mar 3 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10
A mar 4 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10
A mar 5 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10

A mar 5 50 50 50

A 12 120 120 120

B jan 1 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10
B jan 2 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10
B jan 3 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10

B jan 3 30 30 30

B feb 1 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10
B feb 2 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10
B feb 3 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10
B feb 4 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10

B feb 4 40 40 40


B mar 1 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10
B mar 2 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10
B mar 3 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 10 10 10

B mar 3 30 30 30

B 10 100 100 100


Actually to show total as month or manager changes, i use subfoot
Could anyone help me to show serialno and reset it as month changes
and tell me how to show space between field being dispayed under subfoot
because when i use subfoot is comes on output like this

a jan 3 30 30 30

i want to give space between these fields.

Can someone help me???
n m sure it will be great help
waiting for you vaueable comment

Thanks,
Sujeet Sharma

in reply to your pm,

SUM ... COMPUTE SERIAL/I8=IF MANAGER NE LAST MANAGER THEN 1 ELSE IF MONTH NE LAST MONTH THEN 1 ELSE 1 + LAST SERIAL;

as for your second question, it looks as tho you do in fact have a space between your elements in your subtotal row. if you want the numeric values to be underneath their respective columns, use SUBTOTAL

Edit your profile now to say what operating systems, products, and release versions you are on.

Hi susannah,

your solution to put serial no,is working for me.thanks alot.
As you suggest we can use subtotal to show summed values underneath their respet columns.
I tried it.But I want to show total whose title will contain the manager name and month.If i will use subtotal,then it will show only manager name because we can subtotal on one By feild.
if i will put subtotal on both manager and month,then it will give result like this.

manager......................sum sum sum
month........................sum sum sum


but i need like

manager........month.....sum...sum...sum

thats why i used subfoot.but when i used subfoot
it came like this-

manager month sum sum sum

i found no space between them

now i want to put space between them.

can you please suggest something.

Thanks
sujeet sharma

using
winxp/webfocus

SP/A1 = HEXBYT(160, 'A1');
SP02/A2 = SP|SP;
SP05/A5 = SP|SP|SP|SP|SP;

This creats spaces..that you can use in your subfoot..just insert as a field.