Pivot Table empty line field [closed]
I have a pivot table with 3 line fields (the 1st field is to classify, others are only to show some text information) and a single data field (sum).
How to get rid of the "(empty)" value? I would like to change it to something else... but data source will not be changed (that's, source has empty cells).
I want to change "(vazio)" to "..." or something else like " " (single space).
thanks very much, yours, Daniel, from Brazil
**Source Data**
Class InfoText1 InfoText2 Data
1 qwe here 10
2 rty there 20
3 asd 30
1 fgh now 10
2 zxc then 20
3 vbn 30
**Pivot Table**
Class InfoText1 InfoText2
1 fgh now 10
qwe here 10
2 rty there 20
zxc then 20
3 asd **(vazio)** 30
vbn **(vazio)** 30
Total Resultado 120
Thanks very much for suggestions.
Best solution was to create a new column with function "IF(CellIsEmpty; SpaceChar;CellValue)" and use this new column as data source for pivot table.
Changing value of data source (by Find&Replace) is not applicable. Users will not fill empty cells with something only because they shall/must do it... Empty cell is what it is, empty value.
LO-CALC must handle this in a better way, as MO-Excel does! This looks like bugware :-(