I have a pivot table where the data looks like this:
Rows: Employee
Columns: Date
Measures: Date(Max(SubmissionTime), 'hh:mm TT')
Where SubmissionTime is the time an employee turned in a document. This pivot table looks at the last time each day that an employee submitted a document.
There is another field called SubmissionType with possibly values of "Home" and "Remote". I would like to add this data to my pivot table.
I tried using the formula: If(SubmissionTime = Max(SubmissionTime), SubmissionType) but this results in no data.