LivChart Support
We are offline now; you can leave your message.
Our support team is offline from 22:00 to 09:00 Turkey time. We will still receive your message and reply as soon as possible.
You can write freely in your own language. Our operators reply in Turkish through LivAICloud; the system translates messages into your language.
Multi-level rows, columns, measures and business calculations

Advanced Pivot Analysis

The shared Pivot Builder supports hierarchical row and column dimensions, multiple aggregate or formula measures, scoped filters, totals, Top N, sorting and conditional formatting.

Try the Live Demo All Features
V2 shared specification
Live preview and formatting
Real product workflow

What this feature delivers

Pivot analysis gives users a controlled cross-tab workspace for questions that are too detailed for a single chart. The same versioned Pivot specification works in Dashboard Manager, saved dashboard edit mode and Dynamic Dashboard edit mode.

Hierarchical layout

Order multiple row and column dimensions, apply date grains and control initial expansion, subtotals and grand totals.

Measures and formulas

Combine sum, average, count, distinct count, min and max with safe formula measures, percentages, running totals, differences and rank.

Presentation and interaction

Use Top N, number formats, thresholds, color scales and data bars while keeping leading row labels pinned during horizontal scrolling.

Use case

These steps show the need this feature solves for a real team and how it moves analysis closer to action.

Build the layout

Drag searchable fields into rows, columns, measures and filters.

Refine the analysis

Set sorting, time grain, calculations, totals, Top N and conditional formats.

Validate in context

Review the live preview, dashboard interactions, mobile layout and export width before saving.

Enterprise control

One Pivot contract across dashboard editors

Focused manual or AI edits preserve unrelated Pivot settings, while validation checks field names, measure references, filters and preview budgets.

Who is this feature for?

Analysts and operational teams can build detailed cross-tab comparisons without custom SQL, while dashboard designers keep layout and export behavior controlled.

Does it work with other LivChart workflows?

Yes. The same builder and Pivot specification are used in Dashboard Manager, personal dashboard editing, Dynamic Dashboards and Dashboard Chat updates.

Try LivChart with your own data

Connect Excel, CSV or database data and test AI charts, dashboards and reports with a local-first architecture.

Download for Free