Use this skill when users ask how to build or customize Syncfusion PivotView pivot tables in Angular. Trigger for Angular pivot grid/OLAP, aggregation, data binding (JSON/remote), drill-down/drill-through, grouping, filtering, conditional formatting, exports (Excel/PDF/CSV), or pivot charts. Angular-only, not React/Vue/Blazor.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
A direct command skips the review prompt. Inspect the source before running it.
Use this skill when users ask how to build or customize Syncfusion PivotView pivot tables in Angular. Trigger for Angular pivot grid/OLAP, aggregation, data binding (JSON/remote), drill-down/drill-through, grouping, filtering, conditional formatting, exports (Excel/PDF/CSV), or pivot charts. Angular-only, not React/Vue/Blazor.
The Syncfusion Angular Pivot Grid is a powerful data visualization and analysis component for creating interactive pivot tables, aggregating multidimensional data, and performing advanced analytics operations.
Important: Always verify API class names, properties, and method signatures by consulting the reference files in this skill (references/*.md). These are maintained with verified, working examples. Do not assume API details from other sources.
⚠️ Security Warning: Data Source Validation
CRITICAL SECURITY NOTICE: When implementing pivot tables, always use trusted data sources. Never fetch or bind data from untrusted or user-provided URLs without proper validation and sanitization.
Security Best Practices:
Use Local Data: Prefer local, in-memory data sources for maximum security
Validate Remote Sources: Only connect to authenticated and authorized API endpoints under your control
Sanitize User Input: Never allow users to specify arbitrary URLs or data sources
Implement Authentication: Always use authentication headers and secure API endpoints
: Validate and sanitize all data received from external sources before binding
Content Validation
Use HTTPS: Always use HTTPS for remote data connections
Rate Limiting: Implement rate limiting on API endpoints to prevent abuse
Security Risks:
Indirect Prompt Injection: Untrusted third-party data can contain malicious content that manipulates AI agent behavior
Data Exfiltration: Malicious data sources could attempt to extract sensitive information
Code Injection: Untrusted data may contain scripts or harmful content
Recommended Approach:
✅ DO: Use controlled, authenticated backend APIs
✅ DO: Implement server-side data validation
✅ DO: Use environment variables for API endpoints
✅ DO: Whitelist allowed data sources
❌ DON'T: Accept user-provided URLs
❌ DON'T: Bind to public, untrusted endpoints
❌ DON'T: Skip data validation and sanitization
❌ DON'T: Use HTTP for sensitive data
When to Use This Skill
Use this skill when users need to:
Create and configure pivot tables from multidimensional data
Bind data from OLAP or relational data sources
Aggregate data with multiple aggregation functions (Sum, Avg, Count, etc.)
Group data by number ranges, dates, or custom categories
Create and manage calculated fields with formulas
Enable drill-down and drill-through operations
Visualize data with integrated pivot charts
Apply custom formatting and conditional styling
Optimize large dataset performance
Export pivot grid data to Excel or PDF
Persist and restore pivot grid state
Customize UI with field lists, grouping bars, and toolbars
Installation and package setup (Angular 21 standalone architecture)
Basic Angular Pivot Grid implementation
Theme packages — use the consolidated @syncfusion/ej2-{theme}-theme packages (e.g. ej2-material3-theme) with a single styles/pivotview/index.css import
Pattern 1: Multiple Fields with Different Aggregation Types
Each field supports only ONE aggregation type. To analyze different aspects, use different fields with their respective aggregation functions:
values: [
{ name: 'Amount', type: 'Sum' }, // Total sales amount
{ name: 'Quantity', type: 'Avg' }, // Average quantity sold
{ name: 'Sold', type: 'Count' }, // Number of transactions
{ name: 'Price', type: 'Min' }, // Minimum price
]
Note: Each field in the values array can only have ONE type. To get multiple aggregation types for analysis, use different fields or create calculated fields combining aggregations.
Restrict aggregation dropdown to specific types (array of AggregateTypes)
showAggregationOnValueField
Boolean
dataSourceSettings
Display aggregation type in grouping bar button text (e.g., "Sum of Amount" vs "Amount")
sortSettings
Array
dataSourceSettings
Configure field sorting with order, membersOrder, name properties
enableValueSorting
Boolean
Component
Enable sorting by aggregated values
allowMemberFilter
Boolean
dataSourceSettings
Enable/disable member filter UI (default true)
allowLabelFilter
Boolean
dataSourceSettings
Enable label filter UI for header text/number/date filtering
allowValueFilter
Boolean
dataSourceSettings
Enable value filter UI for aggregate-based filtering
filterSettings
Array
dataSourceSettings
Programmatic filter criteria with name, type (Include/Exclude/Label/Number/Date/Value), condition, value1, value2, measure, items, levelCount, selectedField
condition (Top/Bottom)
String
filterSettings (type: 'Value')
Top/Bottom N members by aggregated value of the chosen measure (client-side only)
maxNodeLimitInMemberEditor
Number
Component
Max members shown in the Member Editor before showing a "more items" message (default 1000)
loadOnDemandInMemberEditor
Boolean
Component
OLAP-only: load only the first hierarchy level until expansion/level-select (default true)
Important: When adding calculated fields to values, use type: 'CalculatedField' to distinguish them from regular aggregations. Format settings must be applied in a separate formatSettings array, not within the value field object.
Next Steps
Foundation (Start here):
Read Getting Started for setup and initialization
Read Aggregation to implement aggregation functions and base field aggregations
Read Grouping to configure number, date, and custom grouping
Data Manipulation:
4. Read Calculated Fields for complex calculations and custom field formulas
5. Read Filtering & Sorting for label/value filtering and custom sorting
6. Read Data Formatting for number formats and conditional formatting
Visualization & Interaction:
7. Read Pivot Chart Integration for charting and drill operations
8. Read UI Customization for toolbars and custom interfaces
9. Read Drill-Down & Drill-Through for hierarchical data exploration
Advanced Features:
10. Read Export & Printing for multi-format export (Excel, PDF, CSV)
11. Read State Persistence for saving and restoring configurations
12. Read Database Connections for SQL/NoSQL/big data integration
13. Read Server-Side Pivot Engine for processing 100K+ rows on backend
14. Read Performance Optimization for large datasets, deferred updates, and virtual scrolling
Foundational References
These files provide foundational knowledge and may be referenced by feature guides:
📄 references/core-concepts.md - Data binding types (JSON, CSV, OLAP), client-side vs server-side comparison, choosing appropriate data sources
