RayCraftDocs
v1.0.3 raycraft.dev
On this page

PivotGrid

Complete

Summarizes a list into a cross-table: fields on the rows, fields across the columns and figures in the cells, with subtotals, grand totals and a field chooser.

Example

PivotGrid control

Parameters

API

ParameterTypeDescription
ClassstringExtra CSS classes added to the root element.
DenseboolUses tighter cell padding.
ExportFileNamestringFile name of the CSV export, without the extension.
FieldsRenderFragmentThe fields that can be filtered.
ItemsIEnumerable<TItem>The items to summarize.
LabelstringVisible label text (charts: accessible name; IconButton: accessible name and tooltip).
ShowColumnSubtotalsboolAdds a subtotal column after the columns of each upper column level.
ShowExportboolAdds a button to the toolbar that saves the table as a CSV file.
ShowFieldZonesboolShows the fields in zones that accept drag and drop (hidden, rows, columns, values).
ShowGrandTotalsboolAdds a total row and, when there are column fields, a total column.
ShowToolbarboolShows the toolbar with the field chooser and, when set, the export button.
StylestringInline style added to the root element.

PivotField

ParameterTypeDescription
AggregateDataGridAggregateAdds a summary row value: Sum, Average, Min, Max or Count.
AreaPivotAreaWhere the field starts: Row, Column, Value or Hidden.
FormatstringFormat string for numbers and dates, e.g. N0 or d.
TitlestringTitle text (drawer header, tab caption, column header, step caption).
ValueFunc<TItem, Object>Reads the value of the field from an item.

Events

API

EventTypeDescription
OnCellClickEventCallback<PivotCellClick<TItem>>Raised when a figure is pressed, with the row and column keys, the figure and the items behind it.

Package

PivotGrid is part of RayCraft Complete. Package: RayCraft.Blazor.Complete. It comes from the private RayCraft feed and needs an active license. See Getting started.