actually we have to create a calculated dimension in that list box.in our database there are 2 diff. fields namely "Invoice Quantity" and "Contract Quantity" in two diff. tables.we want to show the calculated dimension (Contract Quantity - sum(Invoice Quantity) ) as "Contract Status" so that it can work on individual item seperately.and we also want to asign two values in the list box "Contract Status" namely "PENDING"(if "Contract Status">0) else "COMPLETED".
