how can find total for sales amount

[rish_sai]

Hi,

how can i subtract country sales for total linesalesamount and i should only see remaining balance in straight table.

Ex:   total linesalesamount is $13,321,238.07 and austria sales amount $408404.49,

here can i see remaining balance in straight table.

i'm trying .

plz help me out

Thanks in Advance.....

[avinashelite]

Try like this

Sum({1}Sales)- sum(Sales)

[its_anandrjs]

Try

Sum ( Sales )

/

Sum( Total Sales )

Elaborate more on the requirement.

Regards

Anand

[tamilarasu]

Hi,

Try like below,

Sum(Sales) - Sum(Total Sales)