Gnumeric warning message while adding pivot tables

Asked By Clint J Thorp 0 points N/A Posted on - 09/12/2013

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

• Status: Open
• Question Views: 1251
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Misc Software

Answered By Vincent Maez 0 points N/A #183484

Gnumeric warning message while adding pivot tables

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.

About Vincent Maez

Questions
3

Answers
102

Best Answers
24

• Vote Up 0 Vote Down

• Posted on - 11/15/2013
• Question Category: Misc Software