pt_rendercreate: Create and Render Budget Pivot

View source: R/pivot_tables.R

pt_rendercreateR Documentation

Create and Render Budget Pivot

Description

Creates and renders budget pivot table in one step

Usage

pt_rendercreate(
  df,
  rowvec = NULL,
  colvec = NULL,
  calcrow = F,
  .ptsavename = NULL,
  deptadjust = F
)

Arguments

df

Dataframe to represent in budget pivot table

rowvec

Columns of dataframe to add as row-groups to budget pivot table; default NULL, for none

colvec

Columns of dataframe to add as column-groups to budget pivot table; default NULL, for none

calcrow

Whether to display year columns as rows of budget pivot table; default F

.ptsavename

Filename of outputted Excel document that contains pivot table; default NULL, in which case pivot table not saved as Excel doc

deptadjust

Whether you're generating pivot tables to share with departments that include comparisons with the adopted budget book; default F, so no adjustment made

Value

Rendered pivot table of budget data


dpowerstp/tpbudget documentation built on June 3, 2022, 1:41 a.m.