title: Google Data Studio - Compare months year-to-year from Google Sheets data
body: <p>I'm using Google Data Studio to plot the monthly revenues in our restaurant. So let's say I have a Google sheets with 2 columns:
  - column A: date
  - column B: day revenue</p>
  
  <p>My Google sheets contains this data for several years now with on each row the day revenue for that day (see screenshot below).</p>
  
  <p>I already added this Google sheet as a data source in my Google Data Studio and now I want to create a line diagram showing the 12 months and when hovering over a certain month I want to show the aggregated sums for that month over the different years (see screenshot 2 below)</p>
  
  <p>How can I configure such diagram using the data in my Google sheets?</p>
  
  <p>Thanks a lot for the help.</p>
  
  <p><a href="https://i.stack.imgur.com/ZNcCM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZNcCM.png" alt="Google sheets data"></a></p>
  
  <p><a href="https://i.stack.imgur.com/KoGBJ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KoGBJ.png" alt="Google Data Studio line diagram"></a></p>