Question: Assuming I've created a pivot with Years and Months on the Rows panel and a Sales measure on the Columns panel. How do I calculate the average sales per day for each month? 1. Create a Custom Measure by right-clicking the Measures node in the Data Browser. 2. Create the following formula...