title: Struggling to Create a Pivot Table in R
body: <p>I am very, very new to any type of coding language. I am used to Pivot tables in Excel, and trying to replicate a pivot I have done in Excel in R. I have spent a long time searching the internet/ YouTube, but I just can't get it to work. </p>
  
  <p>I am looking to produce a table in which I the left hand side column shows a number of locations, and across the top of the table it shows different pages that have been viewed. I want to show in the table the number of views per location which each of these pages.</p>
  
  <p>The data frame 'specificreports' shows all views over the past year for different pages on an online platform. I want to filter for the month of October, and then pivot the different Employee Teams against the number of views for different pages. </p>
  
  <pre><code>specificreports &lt;- readxl::read_excel("Multi-Tab File - Dashboard 
  Usage.xlsx", sheet = "Specific Reports")
  
  specificreportsLocal &lt;- tbl_df(specificreports)
  specificreportsLocal %&gt;% filter(Month == "October") %&gt;%
                       group_by("Employee Team") %&gt;%
  </code></pre>
  
  <p>This bit works, in that it groups the different team names and filters entries for the month of October. After this I have tried using the summarise function to summarise the number of hits but can't get it to work at all. I keep getting errors regarding data type. I keep getting confused because solutions I look up keep using different packages.</p>
  
  <p>I would appreciate any help, using the simplest way of doing this as I am a total newbie! </p>
  
  <p>Thanks in advance,
  Holly</p>