
I have a 10.1 workbook that shows the following:
Vendor, Receipt Amount, Receipt#
if there is a vendor that the same amount from multiple receipts, I'd like to count that the number of times that Receipt Amount has occurred. I'm having trouble getting that calculation b/c Receipt Amount is not at lowest level of detail. The lowest level of detail is at the item code level. I've tried everything but nothing seemed to work. The count that shows up is the count of receipts for that payee; not for the amount.
For example,
VendorSum of Receipt# of Receipts < Need Help getting this calculation>Receipt #ADC Construction$3431.002254771260916
ADC Construction LLC $3431.00 154771
Message was edited by: Marina Derechinskaya