title: How to view a pivot table with actual column values like access in excel
body: <p>I've tried searching this but couldn't find an answer because of the wording of the question. If it's been asked before please point me in the right direction.</p>
  
  <p>I have the same exact data in Excel and Access, however, the pivot tables are viewed differently as shown below:</p>
  
  <p><strong>Excel view and data</strong>
  <img src="https://i.stack.imgur.com/y0Qjn.png" alt="Excel-example"></p>
  
  <p><strong>Access view, same data</strong>
  <img src="https://i.stack.imgur.com/DhZLd.png" alt="Access-example"></p>
  
  <p>As you can see the pivot table in access has the actual values (Y, N) whereas in excel it sums up the values. I want excel to display the actual values like Access and not the sum.</p>
  
  <p>I'll be switching over to Office 2013 soon and need to know how to do this in Excel 2013 since pivot tables were removed from Access 2010 in Access 2013. </p>
  
  <p>I have also tried adding data to the columns section but doing so gave a harder to follow and different view as shown below:</p>
  
  <p><img src="https://i.stack.imgur.com/iOhqX.png" alt="Different view"></p>