View original (French)

[Calc] delete the word "empty"

tsing Posted messages 72 Registration date   Status Member Last intervention   -  
eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   -
Hello,
How to remove the "(empty)" label from empty rows in a pivot table?

Thank you
latest version of LibreOffice,

3 answers

Answer 1 / 3
yclik Posted messages 69 Registration date   Status Member Last intervention   1 607
 
Hello
Right-click on the TCD result table > Layout
Plus button
Check '"Ignore empty rows"
3
tsing Posted messages 72 Registration date   Status Member Last intervention   80
 
Thank you yclik, but it's not the empty line; it's actually some cells in certain rows (sorry for the imprecision!)

and it's that "(empty)" that I would like to remove.
0
Answer 2 / 3
Raymond PENTIER Posted messages 58207 Registration date   Status Contributor Last intervention   17 476
 
So you need to fill in these cells ...

--
Retirement is great! Especially in the Caribbean ... :-)
Raymond (INSA, AFPA, CF/R)
0
tsing Posted messages 72 Registration date   Status Member Last intervention   80
 
Hey, hello Raymond!
"Fill in the cells": what does that mean? Put something in there?! It's not possible, I can't invent what doesn't exist: a check for example.

While surfing, I read that I needed to put a space somewhere, but I didn't understand where or how?! ...

Does that make sense to you?
0
Answer 3 / 3
yclik Posted messages 69 Registration date   Status Member Last intervention   1 607
 
Hello
Apparently, the result of a Pivot Table shows (empty) if "a row field" in the Pivot Table comes from an empty cell.
In the example below, it indicates empty if a date is missing on the left.
Without a provided example, it is possible to create a formula to obtain - if the cell is empty
example in B2 =IF(A2="","- ",A2)
and select only column B to build the Pivot Table
0
tsing Posted messages 72 Registration date   Status Member Last intervention   80
 
Hello,
Thank you! But I'm lost! Since then, I've also seen that an empty source cell shows "(empty)" in the pivot table (PVT^^); just like in your example.

Our software doesn't look the same, and I don't understand your suggestion!
For example, my source table has 8 columns, and the PVT uses 5 as row fields and 3 as data fields. There's no filter.

LibreOffice may not allow any other solution, without using macros, than filling all the source cells.
0
eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
 
Hello,

what if you uploaded a file so we can see what you're talking about precisely?
eric
0