I created a workbook for calculating aging of the payments.
In the attached workbook, Retainage tab is working perfectly and matches the data provided
For Chase tab: Amount in local cur# matches the data, No of records measure matches the data.
In Current, Over 30 days......, amounts and count do not match the data. I looked into the details and found that Tableau is ignoring the duplicate document numbers.
I am looking for some help with
1. Keeping the duplicate records to get exact count of records and also amount to match the test data
2. Get totals for Current, Over 30 days......,
Thanks for your help
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...