Use this skill whenever the user wants to implement Syncfusion PivotView in TypeScript applications. Triggers include: pivot table, pivot grid, data analysis, OLAP, aggregation in TypeScript context. Covers data binding (JSON, CSV, remote), drill-down/drill-through, grouping, filtering, conditional formatting, exports (Excel/PDF/CSV), and pivot charts. Use for interactive reports and dashboards. Do NOT use for React, Vue, or Angular.
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 whenever the user wants to implement Syncfusion PivotView in TypeScript applications. Triggers include: pivot table, pivot grid, data analysis, OLAP, aggregation in TypeScript context. Covers data binding (JSON, CSV, remote), drill-down/drill-through, grouping, filtering, conditional formatting, exports (Excel/PDF/CSV), and pivot charts. Use for interactive reports and dashboards. Do NOT use for React, Vue, or Angular.
Implementing Syncfusion TypeScript Pivot View
A comprehensive skill for implementing the Syncfusion Pivot View (Pivot Table) component in TypeScript applications. The Pivot View is a powerful data analysis tool that enables users to organize, summarize, and analyze large datasets through interactive drag-and-drop operations, multiple aggregation types, drill-down capabilities, and visual chart representations.
⚠️ 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
Use Configuration: Store API URLs in environment variables or configuration files
Implement Authentication: Require authentication for all database and API connections
Apply CORS Properly: Configure CORS to allow only trusted origins
Security Risks:
Indirect Prompt Injection: Untrusted third-party data can contain malicious content that manipulates AI agent behavior
Data Exposure: Unvalidated remote connections may expose sensitive information
SQL Injection: Unsanitized database queries can lead to data breaches
XSS Attacks: Unescaped data rendered in the UI can execute malicious scripts
✅ Safe: Local data, authenticated APIs under your control, parameterized SQL queries
❌ Unsafe: User-provided URLs, unauthenticated endpoints, hardcoded connection strings
When to Use This Skill
Use this skill when the user needs to:
Create pivot tables or pivot grids for data analysis and reporting
Analyze large datasets with dynamic row/column grouping and aggregations
Build business intelligence dashboards with cross-tabulation and OLAP analysis
Implement interactive data summarization with drill-down/drill-through operations
Visualize aggregated data using pivot charts with multiple chart types
Connect to various data sources including JSON, CSV, remote APIs, and databases (SQL Server, MongoDB, MySQL, PostgreSQL, Oracle, Snowflake, Elasticsearch)
Enable field manipulation through drag-and-drop field lists and grouping bars
Apply advanced filtering (member, label, value filtering) to focus on specific data
Create calculated fields with custom formulas for derived metrics
Export pivot analysis to Excel or PDF formats
Optimize performance for large datasets using virtual scrolling, paging, or compression
Perform OLAP analysis with multidimensional cube data
Trigger Keywords: pivot table, pivot view, pivot grid, cross-tabulation, OLAP, data pivoting, field list, grouping bar, drill-down, drill-through, aggregation, data summarization, business intelligence, multidimensional analysis
Overview
The Syncfusion Pivot View component provides:
Flexible Data Binding - JSON, CSV, remote data sources, SQL databases, MongoDB, OLAP cubes
Interactive Field Management - Drag-and-drop field list and grouping bar for runtime configuration
Multiple Aggregation Types - Sum, Count, Average, Min, Max, Product, DistinctCount, and more
Advanced Filtering - Member filtering (include/exclude), label filtering, value filtering with Top/Bottom operators, sort members, append selection to existing filters, and OLAP load-on-demand
Sorting & Grouping - Sort by rows/columns, group by date intervals (quarters, months, years)
Calculated Fields - Create custom fields using formulas and expressions
Drill Operations - Drill down to expand hierarchies, drill through to view raw data
Inline Editing - Edit aggregated values directly in the pivot table
Pivot Charts - Visualize data with 21 chart types including Column, Line, Pie, Bar, Area, and more
Export Capabilities - Export to Excel and PDF with formatting preservation
Performance Features - Virtual scrolling, paging, data compression, defer update
Rich Formatting - Number formatting, conditional formatting with color scales and data bars
Accessibility - WCAG compliant with keyboard navigation and screen reader support
