title: Excel pivot table "Distinct Count" not compatible with Group for dates?
body: <p>Using Excel 2013, I need a pivot table which:</p>
  
  <ul>
  <li>Counts unique values in a field ('Distinct Count')</li>
  <li>Groups the data by Year and Quarter </li>
  </ul>
  
  <p>If I create the pivot table by checking "Add this data to the Data Model" then the "Distinct Count" option is available as expected. However, I cannot group my date columns (both Group and Ungroup are grayed out), making the report unusable.</p>
  
  <p>OTOH if I don't check "Add this data to the Data Model" when I create the pivot table, Grouping dates works fine but I lose the "Distinct Count" option as expected. Exact same data with date column formatted as short date.</p>
  
  <p>Can someone verify and/or enlighten me about the reason?</p>