set_page: Set page information to a pivot table

In flattabler: Obtaining a Flat Table from Pivot Tables

Set page information to a pivot table

Description

Define the page information associated with a pivot table. Previously existing information is replaced by new information.

Usage

set_page(pt, row, col, page)

## S3 method for class 'pivot_table'
set_page(pt, row = 0, col = 0, page = "")

Arguments

pt	A pivot_table object.
row, col	A cell (row and column number), page information included in the table.
page	A string, page information.

Details

Each pivot table implements a report. The pivot table page represents the context of that report. It is useful when we work with several pivot tables with the same structure: for example, the page can allow us to differentiate their origin, date or author. This information is often included in the file name, sheet name, or a cell attached to the pivot table.

Value

A pivot_table object.

See Also

pivot_table

Other pivot table definition functions: define_labels(), get_page(), pivot_table()

Examples

pt <- pt_ex |> set_page(1, 1)

pt <- pt_ex |> set_page(page = "M4")

flattabler documentation built on Sept. 15, 2023, 1:06 a.m.