Gnumeric warning message while adding pivot tables

Asked By 0 points N/A Posted on -
qa-featured

Hi,

The following error message occurred adding Support for Pivot Tables to Gnumeric. What does it mean by “The value you entered is out of allowed range 2.10”. Has any idea or solution to fix this issue ASAP? Any help would be appreciated. Thanks in advance.

Gnumeric warning

The value you entered is out of allowed range 2.10

SHARE
Answered By 0 points N/A #183484

Gnumeric warning message while adding pivot tables

qa-featured

You can use the DSUM function instead because Gnumeric doesn't support pivot tables. It will calculate the sum but it it will not give you the sum for all items automatically. That is why you need to insert DSUM functions and criteria table for every item you input. It's a bit of a hassle to use it but it is a solution. Here's an example I am attaching. cell f2 has =dsum (a2:c6;3;a9:c10):a2:c6 is the database on light green. 3 is the column that sums up which is "amount". a9:c10 is the criteria table on light cyan. Only rows with Apple are selected.

 

The other option is for you to use LibreOffice.

Related Questions