1 Reply Latest reply: Jul 28, 2017 1:10 AM by Arvind Patil RSS

    How to use two measures based on two different date fields in a single pivot table?

    Melissa Principe

      I want to use two measures based on two different date fields in a single pivot table.  There are several key fields in my data, but below is a simplified example of the data in my load script:

       

      Table 1:

      User Id

      SalesMonth

      Amount (amount sold in dollars)

       

      Table 2:

      User Id

      QuotaMonth

      Quota (sales goal in dollars)

       

      The tables are joined on UserId, and renaming the month fields as the same field name creates a synthetic key. My goal is to have the Month going across the top of the pivot table, with Quota and Amount as measures beneath each month (so we can do a side-by-side comparison of sales quota vs. amount sold in a pivot table).  Any help is appreciated!