My data looks something like this:
and so on until December. I want to add a row below every month which give the values- Total no of calories, no of days worked out- a basic summary. I have tried to use dplyr & tidyverse but not getting the correct results & the format I want it in.
The below script gives me by Month but I cannot add a new row.
summarise(Total_Cal = sum(Calories))