Pivot based of a field

[senthilmek]

Is it possible to pivot based of a field here .In case of mtcars how would I create a pivot between cyl and gear and the value being mpg.

mtcars %>%
  pivot_table("cyl", "gear") %>%
  pivot_format(
    # background = "#D8DEE9",
    # color = "#3B4252",
    # labels = pivot_labels(
    #   n = "mpg"
    )
  )