0 Replies Latest reply on Jan 9, 2014 1:57 PM by Latha vinnakota

    Duplicate and issue with totals

    Latha vinnakota

      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

      Latha