My company is using Microsoft SQL Server 2000 on a Windows 2000 server, in its head office location. We have a second office, which is connected to head office via a 2Mb fixed link - users of the databases in that second office are connecting directly to the server in the head ...
1. I got the price and the qty in the data source. when I create the calculated member Amount = Qty * price, I found out the total is equal to the total qty * total price. How can I define the calculated member Amount = summation of (qty *