I am having problems in create a report table with a data frame like this:

   id sex    age    location
   1   m   0-17       Miami
   2   f  18-64 Los Angeles
   3   f over64     Ontario
   4   m  18-64       Paris
   5   m  18-64     Ontario
   6   m over64       Miami
   7   f over64       Miami
   8   f  18-64 Los Angeles
   9   m  18-64       Other
  10   m over64       Other

my desired table should look like this:

If you want to customize it, pipe in as_gt() and then use any of the functions in the gt package to customize it further.