How to store the calculated data value of two different fields say invoice(weight) and contract(weight) which are in different tables and i want to subtarct the values of two fields and want to show in a Pivot Table and want to make a list box with heading Status underneath Complete/Pending will show.When i will clikc on Complete on list box it the pivot table will show all complete records.
Actually u are taking status field and make in complete or pending which is much more like hard code i just want to make that contract (weight)- invoice(weight)>0 then pending else complete
