Created attachment 97954 [details]
a ods file which shows how pivot should be like to make it much faster and useful
Just see my attached 10000-row example. Try to add one more data field, you will see that calc takes a long time to draw the data.
Currently when you insert a pivot table, data fields are placed at rows. This makes pivot table freeze and useless in large spreadsheet files which contain a large amount of rows.
For example, for a pivot table with 10000 rows in the row field, when you add 2 data fields you get 20000 rows, when add 3 data field you get 30000 rows....
The most importantly, "data fields at rows" is not good for data analysis. I guess very few people like this layout. The good layout of pivot table should be like this:
I see from here:
that Tomaž Vajngerl has done some pivot table layout change. however I do not understand the codes issue. maybe my enhancement request is already incorperated in the above commit?
I tried to cc Tomaž Vajngerl but failed.
Created attachment 98346 [details]
It is implemented in the future 4.3, see attachment.
When you create a pivot table, you see a field named "Data" in the column field.
This field let you choose if you want data fields in the same column or not.
(You can drag him either in Row or Column).
He is by default in Column witch is what you want, I think.
Created attachment 98369 [details]
Sample file modified.
If I have understood right, this is possible now, in released versions, dragging the field by their head directly in the sheet from row to column (without enter in edit layout).
Seems that drag in the sheet doesn't work with:
Version: 22.214.171.124.alpha1+ Build ID: 0b03f7ed575838f90e6b1ebec3538a3a214f81fb
TinderBox: Win-x86@39, Branch:master, Time: 2014-04-30_01:30:46
But works dragging "Data" from row fields to column fields in edit layout mode.
In relation with update time, I think master are always a bit slower than released.
I confirm this is fixed in libreoffice 4.3 alpha 1.
Default data field is in column, and users can drag the "DATA" field to rows if needed.
Created attachment 102605 [details]
Test ods file showing the improvements in 4.3 version
This is a really great improvement,
I think it should belong to the release notes:
I realize this won't be undone but as someone who uses a lot of pivot tables and data manipulation - having a completely false and non-existent "data" field was ultra confusing as "data" didn't correspond with a single field in any of my spreadsheets.
Not a huge fan but I realize it won't be undone
(In reply to Joel Madero from comment #6)
> I realize this won't be undone but as someone who uses a lot of pivot tables
> and data manipulation - having a completely false and non-existent "data"
> field was ultra confusing as "data" didn't correspond with a single field in
> any of my spreadsheets.
> Not a huge fan but I realize it won't be undone
It won't be undone as the "data" field has a purpose - however it doesn't need to be done as it is now - so do you have any suggestions how to improve the dialog?
Well I think at minimum there should be a real field there....then the issue is "what field" in which case it'll be entirely a guess. I think "data" makes absolutely no sense, at least using a real field (an actual column that exists) makes it so users aren't like WTF when they see "data" in the row.
I think the best guess is the first column of the selected data - from my extensive use of pivot tables, this is generally (although not always) one of the fields that is used to query on