I’m trying to create a Pivot Table w/ Heatmap report showing historic data for the last 6 months for two data points (let’s call them Customers and Profit) for each of my different associates but in the same report I’d like to see the most recent dat...