[Solved] Repeating Item Labels in Pivot Table
[Solved] Repeating Item Labels in Pivot Table
I have Google'd and ChatGPT'd the heck out of this problem and am not able to figure it out. I have a simple pivot table and can not locate anything that will help me turn on repeating item labels. See first table below (sample worksheet). Here are the steps I've taken:
1. Right click on table and select "edit layout"
2. Double-click on the "date" field to open up the Data Field dialog box.
3. Click "options" - nothing there to solve my problem.
Another way:
1. same as above
2. Click "more" in the bottom right corner - nothing there to help either.
I'm used to working in Excel, but this particular client uses OpenOffice. It's driving me nuts, what am I missing?
1. Right click on table and select "edit layout"
2. Double-click on the "date" field to open up the Data Field dialog box.
3. Click "options" - nothing there to solve my problem.
Another way:
1. same as above
2. Click "more" in the bottom right corner - nothing there to help either.
I'm used to working in Excel, but this particular client uses OpenOffice. It's driving me nuts, what am I missing?
- Attachments
-
- screenshot.jpg (30.26 KiB) Viewed 1873 times
Last edited by SRHPHR33 on Mon May 22, 2023 4:29 pm, edited 1 time in total.
OpenOffice 4.1.14 on Windows 11
Re: Repeating Item Labels in Pivot Table
2. Select the first empty cell to be filled (below 05/01/23 on your picture) until the last empty cell to be filled.
3. Copy the selected range.
4. Type a formula like =A5 (reference to the cell above the active cell) and confirm the input with Alt+Enter which fills the entered formula into the whole range selection.
5. Paste-special [Ctrl+Shift+V], choose "All" plus "Skip empty cells".
The result is a range of formulas, each one referencing the above neighbour with the constant data pasted back in step 5.
karolus recalled the right option.
Last edited by Villeroy on Sun May 21, 2023 1:32 pm, edited 1 time in total.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Repeating Item Labels in Pivot Table
Hallo
In the Pivottable-Layout-Dialog***: →→doubleclick 'Date' →Options→→[x]repeat Labels →→ok→→ok
In the Pivottable-Layout-Dialog***: →→doubleclick 'Date' →Options→→[x]repeat Labels →→ok→→ok
Libreoffice 7.4 on Debian 12 (Bookworm) (on RaspberryPI4)
Libreoffice 7.6 flatpak on Debian 12 (Bookworm) (on RaspberryPI4)
Re: Repeating Item Labels in Pivot Table
Thank you so much @karolus, but that doesn't work either. This is what I see once I double click Date, then Options:
- Attachments
-
- screenshot2.jpg (45.02 KiB) Viewed 1704 times
OpenOffice 4.1.14 on Windows 11
Re: Repeating Item Labels in Pivot Table
If you attach a small example file instead of screenshots, we don't need to guess how the data look like and can try out solutions without entering data.
AOO 4.1.15 & LO 24.2.2 on Windows 10
Re: Repeating Item Labels in Pivot Table
Great idea! Here you go......thanks so much for taking a look at it.
- Attachments
-
- Practice.ods
- (12.16 KiB) Downloaded 44 times
OpenOffice 4.1.14 on Windows 11
Re: Repeating Item Labels in Pivot Table
- Attachments
-
- Practice2.ods
- (11.43 KiB) Downloaded 41 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Repeating Item Labels in Pivot Table
Rightclick on the pivot table, Edit Layout, drag Description from the Row fields to the Column fields and Net from the Row fields to the Data fields. Press OK. That's probably what you intended.
AOO 4.1.15 & LO 24.2.2 on Windows 10
Re: Repeating Item Labels in Pivot Table
Thank you so much, but how in the world did you do this? I'm looking at the pivot table set up and it doesn't look different to me, from what I had originally.
OpenOffice 4.1.14 on Windows 11
Re: Repeating Item Labels in Pivot Table
Thanks for replying! Almost, it solved the problem for the Description, but the Date (that is in the row field), still does not have the repeating dates displayed.
OpenOffice 4.1.14 on Windows 11
Re: Repeating Item Labels in Pivot Table
Replace OpenOffice with LibreOffice and the feature will be available for all row and column fields, together with hundreds of other things.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Repeating Item Labels in Pivot Table
There's only one row for each date, so there's nothing to repeat.
AOO 4.1.15 & LO 24.2.2 on Windows 10
Re: Repeating Item Labels in Pivot Table
Ahhh, ok - thank you so much!
OpenOffice 4.1.14 on Windows 11