libre office calc pivot table

E

ericj

New Member
Joined
Mar 16, 2011
Messages
13
Hello,
I know this site is for excel but I am trying to help a senior citizen using Libre Office Calc. He is trying to remove retained items in a pivot table. I know how to do it in Excel but not Calc. Does anyone know of a similar message board like MrExcel for libre office calc?
Here is how to remove retained pivot table items Excel Pivot Table How to Clear Old Items Easy Steps
Thank you
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
Sort by date Sort by votes
Are you trying to delete a row or column of data in Libre.
What do you call retained items....can you post a screenshot with a better explanation ?
 
Upvote 0
In a pivot table filter there are items that are no longer being used. Want to get rid of those items that are no longer in the data table. Here is a link with examples of exactly what I am trying to do but in libre office calc. Excel Pivot Table How to Clear Old Items Easy Steps

Change Retain Items Setting in Excel​


To prevent old items from being retained in a pivot table, you can change an option setting:
  1. Right click any cell in the pivot table
  2. Click on PivotTable options
  3. In the PivotTable Options dialog box, click on the Data tab
  4. In the Retain Items section, select None from the drop down list.
  5. Click OK, then refresh the pivot table.
 
Upvote 0
As requested previously, ca you post a screenshot of the sheet, or upload to a hosting site, dropbox for instance, and then post the link to that sheet back here.
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question
Excel pivot table query - retaining filters on pivot in absence of data
2
Replies
10
Views
1K
Alex Blakenburg
A
S
  • Question
Repeating a pivot table many times and changing only one column -- are there more efficient approaches?
Replies
0
Views
259
sschaefer
S
P
  • Question
"Include new items in manual filter" greyed out when the field is in the filter area of a pivot table
Replies
7
Views
838
RoryA
RoryA
T
  • Question
Display Refresh Date Pivot Table Online
Replies
0
Views
732
tboneotter
T
C
  • Question
Pivot table - sum a number of group
Replies
0
Views
255
Cferron
C

Forum statistics

Threads
1,216,500
Messages
6,131,016
Members
449,615
Latest member
Nic0la

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top