Bug 170527 - Calc Pivot Tables isn't as good as MS Excel's PowerPivot; and it should
Summary: Calc Pivot Tables isn't as good as MS Excel's PowerPivot; and it should
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.0 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2026-01-29 12:25 UTC by pnouwen
Modified: 2026-01-29 12:25 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description pnouwen 2026-01-29 12:25:35 UTC 
Description:
Calc Pivot Tables isn't as good as MS Excel's PowerPivot, and it could be and should be. Or even better.
- The main feature that makes Excel's PowerPivot so good is the option to make very quick analyses on related data; eg. 2 separate tables in teh same worksheet that have a 1-many relation. In excel one can make a pivot table on those 2 tables in 5 minutes. Calc doesn't have a PowerPivot-comparison, so I have to use a Python Jupiter-notebook with Pandas to do the same analysis and it takes me about an hour.

Steps to Reproduce:
I don't know. I'm a user, not a programmer.

Actual Results:
I use PowerPivot on an almost daily basis, so I can't get rid of Microsoft. And I want to...

Expected Results:
A feature in LibreOffice that equals or just plainly beats the usability and range of PowerPivot. (NB. I am impression that MS plugged the feature to work with related datasources is integrated into most or all of the Office-apps.)


Reproducible: Always


User Profile Reset: No

Additional Info:
none