How to use two measures based on two different date fields in a single pivot table?
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!
