Explore the API
Sales analysis with PivotTables
Analyze 288 equipment, consumables, and service orders. Change the grouping, measure, region filter, and layout; compare the PivotChart, then extract the underlying orders.
Try this workflowExplore and compare
Change the inputs, run an action, and inspect the live result below.
ResultLive API output
The chart uses a native pivot binding. Download TXWB to retain the full workbook, or XLSX to inspect its Excel-compatible PivotTable and PivotChart association.
Preparing sample...
Keep exploringReset or save
Reset restores this sample's starting document. TXWB retains its spreadsheet, dashboard, and reporting definitions.
Ready to tryUse the controls above to interact with this demo.
What this demonstrates
Sales analysis with PivotTables
A PivotTable aggregates a named table on Order ledger into ordinary cells on Sales analysis. Calculated Profit evaluates Revenue minus Cost per source record; revenue share uses percentGrandTotal, and average order reaggregates the source records correctly. A bound PivotChart follows report fields, measures, filters, and refreshes. Source edits use manual refresh in this sample so you can compare the cached total before and after refresh. The field list and contextual ribbon provide the same editing operations interactively.
APIs used
sheet.pivotTables.add()
pivot.update()
pivot.createChart()
pivot.refresh()
pivot.drillThrough()
pivot.getData()
editor.ui.pivotTables.show()
How to explore
Analyze 288 equipment, consumables, and service orders. Change the grouping, measure, region filter, and layout; compare the PivotChart, then extract the underlying orders.
The chart uses a native pivot binding. Download TXWB to retain the full workbook, or XLSX to inspect its Excel-compatible PivotTable and PivotChart association.
Document ownership
The ready event supplies the initialized editor. Each action resolves document objects from the current workbook. Reset loads a clean TXWB snapshot; worksheet, range, chart, and dashboard handles must be acquired again after loading.
The Code panel shows this sample's actual implementation and the shared hosting code. Downloads contain the current document; changes are not stored on the server.
NuGet packages
TXTextControl.TXSheetControl.AspNetCore
2.0.0
Provides the Razor spreadsheet editor, browser APIs, and packaged fonts.
dotnet add package TXTextControl.TXSheetControl.AspNetCore --version 2.0.0
