The classic (tabular) form displays the data in an Excel-like layout of hierarchies. Using the classic Angular pivot table, you can see hierarchy sublevels in separate rows or columns next to each other.
Play with the demo on a larger screen: save this link for later or watch the video review now.
import { Component, ViewChild } from "@angular/core";
import { FlexmonsterPivotModule, FlexmonsterPivot } from "ngx-flexmonster";
@Component({
selector: "pivotComponent",
standalone: true,
imports: [FlexmonsterPivotModule],
templateUrl: "./pivot.component.html",
styleUrls: ["./pivot.component.css"]
})
export class PivotComponent {
@ViewChild("pivot") pivotRef!: FlexmonsterPivot;
public report: Object = {
dataSource: {
type: "csv",
filename: "https://cdn.flexmonster.com/data/data.csv"
},
options: {
grid: {
type: "classic"
}
},
slice: {
rows: [
{
uniqueName: "Country"
},
{
uniqueName: "Business Type"
}
],
columns: [
{
uniqueName: "Color"
},
{
uniqueName: "[Measures]"
}
],
measures: [
{
uniqueName: "Price",
format: "currency"
}
],
expandAll: true
},
formats: [
{
name: "",
thousandsSeparator: ",",
decimalSeparator: ".",
decimalPlaces: 2
},
{
name: "currency",
currencySymbol: "$"
}
]
};
changeLayout(layoutType: string) {
this.pivotRef.flexmonster.setOptions({
grid: {
type: layoutType
}
});
this.pivotRef.flexmonster.refresh();
}
setRepeatLabels(enabled: boolean) {
this.pivotRef.flexmonster.setOptions({
grid: {
repeatAllLabels: enabled
}
});
this.pivotRef.flexmonster.refresh();
}
}
<button (click)="changeLayout('compact')">Use compact form</button>
<button (click)="changeLayout('classic')">Use classic form</button>
<button (click)="setRepeatLabels(true)">Repeat labels on</button>
<button (click)="setRepeatLabels(false)">Repeat labels off</button>
<fm-pivot
#pivot
[height]="450"
[report]="report">
</fm-pivot>
With a tabular layout, you have access to the same data visualization functionality as in compact form. All Excel features work the same: via a comfy Angular UI grid, you can sort and filter rows and columns, drill through the data, and expand or collapse the hierarchies.
If the data on your Angular pivot grid has a deep hierarchy with many sublevels, we recommend switching to the compact form, which shows multilevel hierarchies more neatly and saves space on the table.
Can't find your answer here?
Visit the FAQ page
Flexmonster Pivot Table & Charts is a JavaScript pivot table component for adding interactive reporting and data analysis to web applications. Users can summarize, filter, sort, and explore data in pivot tables and charts, drill into results, and export reports.
Flexmonster works in plain JavaScript and TypeScript projects. It also integrates with React, Next.js, Angular, Vue, Blazor, and other technologies. See all integration options.
Flexmonster supports JSON and CSV files, SQL databases, MongoDB, Elasticsearch, and Microsoft Analysis Services (SSAS). You can also connect other data sources through your own backend. See supported data sources.
Flexmonster offers licenses for internal corporate use, SaaS products, and OEM distribution. Pricing varies by license and plan. SaaS projects can also use the free SaaS Entry license during development. Learn more on the pricing page.
Yes. Flexmonster offers a 30-day free trial that lets you evaluate all its features. No credit card is required. The trial version has a watermark.
To get started with Flexmonster, follow our integration guide.