Dates repeating in Pivot Table

[akuttler]

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.

[sunny_talwar · Accepted solution]

Your date might be a timestamp... convert it into a date field like this

Date(Floor("Transaction Date")) as "Transaction Date"

[akuttler]

Yes! Thank you that solved the problem.