2 Replies Latest reply: Feb 6, 2018 11:40 AM by Ashley Kuttler RSS

    Dates repeating in Pivot Table

    Ashley Kuttler

      Hi, I have a pivot table with "Transaction Date" Row Field and a measure "Total Payments Posted"

       

      The expression for "Total Payments Posted" is (Sum({<ITEMTYPE={'I-P','P-P','P'}>}Trans))*-1

       

      Where item type is another field that represents payment type, and trans represents the amount. Payments are negative in the database so I Multiply by -1 so the total will appear as a positive in the visualization.

       

      However, I cant figure out why the dates are repeating in my visualization?

       

      I am connected to 4 database tables all having the same field names and concatenated in my data load script.

       

      Thanks in Advance.

      Capture.PNG