hi i have report like thid
id name location price
1 abc abc 10.0
1 cde ref 20.0
what i want is totls to displa in my table like below
id name location price
1 abc abc 10.0
totallocation 10.0
1 cde ref 20.0
totallocation 20.0
total 30
i created variable and put in group footer but nothing happend, it created total for each line not by particular column?by location , by id
