Loading...

Description

This is an example of the Angular Pivot Grid Component with the pivot values displayed along the pivot columns. The Angular PivotGrid can displays the pivot values fields either below each column or on the right side of each pivot row. The default behavior is to display the pivot values along the columns. To change it this option modify the pivotValuesOnRows property in the pivot data source.

Angular PivotGrid: Pivot Grid with Values on Columns

Description This is an example of the Angular Pivot Grid Component with the pivot values displayed along the pivot columns. The Angular PivotGrid can displays the pivot values fields either below each column or on the right side of each pivot row. The default behavior is to display the pivot values along the columns. To change it this option modify the pivotValuesOnRows property in the pivot data source.

A live Angular example of jqxPivotGrid, the jQWidgets PivotGrid component, with its complete source code below. It is one of 12 jqxPivotGrid demos for Angular.

jqxPivotGrid API used in this demo

Source code

To run it in your own app, install the package with npm install jqwidgets-ng, add these files to a standalone Angular CLI app, and add jqx.base.css and a theme to the styles in angular.json. Getting started with jqxPivotGrid shows the setup step by step.

app.ts

import { Component, AfterContentInit, AfterViewInit, viewChild } from '@angular/core';
import { jqxPivotGridComponent } from 'jqwidgets-ng/jqxpivotgrid';
import { CommonModule } from '@angular/common';
import { jqxPivotGridModule } from 'jqwidgets-ng/jqxpivotgrid';

@Component({
    imports: [CommonModule, jqxPivotGridModule],
  selector: 'app-root',
  templateUrl: './app.html',
  styleUrl: './app.css'
})
export class App {
	readonly pivotGrid1 = viewChild.required<jqxPivotGridComponent>('pivotGrid1'); 

	constructor()
	{
		this.pivotDataSource = this.createPivotDataSource();
	}
	
	ngAfterViewInit(): void {
	   this.pivotGrid1().getPivotRows().items[0].expand();
	   this.pivotGrid1().refresh();
	}
	
	getWidth() : any {
		if (document.body.offsetWidth < 850) {
			return '90%';
		}
		
		return 850;
	}

	pivotDataSource: null;
 
	createPivotDataSource(): any {
		// prepare sample data
		let data = new Array();

		let firstNames =
		[
			"Andrew", "Nancy", "Shelley", "Regina", "Yoshi", "Antoni", "Mayumi", "Ian", "Peter", "Lars"
		];

		let lastNames =
		[
			"Fuller", "Davolio", "Burke", "Murphy", "Nagase", "Saavedra", "Ohno", "Devling", "Wilson"
		];

		let productNames =
		[
			"Black Tea", "Green Tea", "Caffe Espresso", "Doubleshot Espresso", "Caffe Latte"
		];

		let priceValues =
		[
			"2.25", "1.5", "3.0", "3.3", "4.5", "3.6", "3.8", "2.5", "5.0", "1.75", "3.25", "4.0"
		];

		for (let i = 0; i < 100; i++) {
			let row: any = {};
			let productindex = Math.floor(Math.random() * productNames.length);
			let price = parseFloat(priceValues[productindex]);
			let quantity = 1 + Math.round(Math.random() * 10);

			row["firstname"] = firstNames[Math.floor(Math.random() * firstNames.length)];
			row["lastname"] = lastNames[Math.floor(Math.random() * lastNames.length)];
			row["productname"] = productNames[productindex];
			row["price"] = price;
			row["quantity"] = quantity;
			row["total"] = price * quantity;

			data[i] = row;
		}

		// create a data source and data adapter
		let source =
		{
		   localdata: data,
		   datatype: "array",
		   datafields:
		   [
				{ name: 'firstname', type: 'string' },
				{ name: 'lastname', type: 'string' },
				{ name: 'productname', type: 'string' },
				{ name: 'quantity', type: 'number' },
				{ name: 'price', type: 'number' },
				{ name: 'total', type: 'number' }
		   ]
		};

		let dataAdapter = new jqx.dataAdapter(source);
		dataAdapter.dataBind();
		
		// create a pivot data source from the dataAdapter
		let pivotDataSource = new jqx.pivot(
		   dataAdapter,
		   {
				pivotValuesOnRows: false,
				rows: [{ dataField: 'firstname' }, { dataField: 'lastname'}],
				columns: [{ dataField: 'productname' }],
				values: [
					{ dataField: 'price', 'function': 'sum', text: 'sum', formatSettings: { prefix: '$', decimalPlaces: 2 } },
					{ dataField: 'price', 'function': 'count', text: 'count' },
					{ dataField: 'price', 'function': 'average', text: 'average', formatSettings: { prefix: '$', decimalPlaces: 2} }
				]
		   }
		);
		
		return pivotDataSource;		
	}
}

app.html

<jqxPivotGrid
    #pivotGrid1
    [width]="getWidth()" 
    [height]="400"
    [source]="pivotDataSource"
    [treeStyleRows] = "false"
    [autoResize] = "false"
    [multipleSelectionEnabled] = "true"
	>
</jqxPivotGrid>

Learn more

More Angular PivotGrid demos