Re[2]: Query on Calc Pivot Tables

2020-05-15 Thread Steve Fanning
this behaviour might be useful? Regards, Steve -- Original Message -- From: "Kohei Yoshida" To: "Steve Fanning" Cc: libreoffice@lists.freedesktop.org Sent: 15/05/2020 00:07:49 Subject: Re: Query on Calc Pivot Tables On 09.05.2020 12:10, Steve Fanning wrote:

Re: Query on Calc Pivot Tables

2020-05-14 Thread Kohei Yoshida
On 09.05.2020 12:10, Steve Fanning wrote: However Calc also (automatically) puts a field called “Data” in the “Column Fields” area of the dialog. Please could somebody explain what this “Data” field is for? My one-sentence explanation would be: this "Data" field controls the layout of the dat

Query on Calc Pivot Tables

2020-05-09 Thread Steve Fanning
All, I am currently working in the LO Documentation Team, preparing a 6.4 update to the Calc Guide. When you insert a Pivot Table in a spreadsheet, Calc displays the Pivot Table Layout dialog. Initially all relevant fields are placed in the “Available Fields” area of the dialog, ready for the u