Microsoft Excel pivot tables
GPTKB entity
Statements (93)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
gptkb:software
|
| gptkbp:allows |
data filtering
data sorting dynamic data grouping aggregation functions |
| gptkbp:canBeRefreshed |
yes
|
| gptkbp:connectsTo |
gptkb:OLAP_cubes
gptkb:Power_Pivot gptkb:Power_Query gptkb:Excel_tables data models external data sources |
| gptkbp:format |
cross-tabulation
tabular report |
| gptkbp:hasFeature |
sorting
filtering conditional formatting grouping timelines pivot charts slicers classic pivot table layout clear all clear filters column labels compact form defer layout update drill down expand/collapse field buttons field headers field list field list pane field settings grand totals move pivot table multiple consolidation ranges outline form preserve formatting refresh data refresh on open repeat item labels report filter row labels show details show items with no data show report filter pages show values as show values as difference from show values as index show values as percent difference from show values as percent of base field show values as percent of base grand total show values as percent of base item show values as percent of base parent column total show values as percent of base parent field show values as percent of base parent grand total show values as percent of base parent index show values as percent of base parent item show values as percent of base parent rank show values as percent of base parent row total show values as percent of base parent total show values as percent of base parent value show values as percent of base total show values as percent of base value show values as percent of column total show values as percent of grand total show values as percent of parent column total show values as percent of parent row total show values as percent of parent total show values as percent of row total show values as percent of selected value show values as percent running total in show values as percentage show values as rank show values as rank largest to smallest show values as rank smallest to largest show values as running total subtotals tabular form value field settings |
| https://www.w3.org/2000/01/rdf-schema#label |
Microsoft Excel pivot tables
|
| gptkbp:introducedIn |
gptkb:Excel_5.0
|
| gptkbp:partOf |
gptkb:Microsoft_Excel
|
| gptkbp:supports |
drag and drop interface
calculated fields multiple data sources calculated items |
| gptkbp:usedFor |
data analysis
data exploration data summarization |
| gptkbp:bfsParent |
gptkb:Lotus_Improv
|
| gptkbp:bfsLayer |
6
|