0 Replies Latest reply: Nov 2, 2017 5:32 PM by Matt McIlvride RSS

    Include static value in pivot table

    Matt McIlvride

      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.