Forum Discussion
Create a Running Total
AnonymousI hope this will do it. Please check and let us know.
For running totals to work you generally need some kind of numeric value or date that you can compare. I would suggest another table that assigns a number to each of your categories that could serve this purpose.
Unfortunately we don't have any dates within the data. I added a colimn which assigns a 1 for each line item, will this do the job? If it does, how do I go about creating the appropriate measure?
As Greg suggest, add another table for unique categories with a number assigned to each category, which you can add index column using edit query and that will get this going. If you share the data in excel sheet, will get you the solution.
Hi parry2k - Here is a sample of the data you requested I send. Sorry, I had trouble uploading the excel file.
Label
Claim_Type Need Completed Reimbursement Request Form Manual Need Completed Reimbursement Request Form Manual Need Completed Reimbursement Request Form Manual Need Completed Reimbursement Request Form Manual Need Completed Reimbursement Request Form Manual Need Completed Reimbursement Request Form Manual Statement/EOB Required Online Statement/EOB Required Online Statement/EOB Required Online Statement/EOB Required Online Service after end of Coverage Period Online Service after end of Coverage Period Online Balance Forward Online Other Online Payment/Proof of Orthodontia Online EOB Required Manual Letter of Medical Necessity Online No Receipt Online Credit Card Receipts Online Estimated Statement/EOB Manual