Page 1 of 1

Filter function

PostPosted: Mon Apr 25, 2016 2:18 am
by Crash-14
I like this program and have used it extensively. It would be helpful to have a simple filter program vs requiring use of a cumbersome pivot table when the user is simply trying to filter some data.

The help file for the pivot table is not clear as to how to use the [field,filter] function, as no example of this was given in the file.

Code: Select all
Pivot formula examples:

=pivotData(C3:H19, {1},,, {PIVOT::Sum}, PIVOT::ColumnGrandTotals)

=pivotData(sheet1!C3:H19, {1}, {2}, {3, 4}, {PIVOT::Sum, PIVOT::Count}, PIVOT::RowGrandTotals + PIVOT::ColumnGrandTotals + PIVOT::SubTotals)

=pivotData(sheet1!B3:F8, {5, 1}, {3},, {PIVOT::Sum}, PIVOT::RowGrandTotals + PIVOT::ColumnGrandTotals + PIVOT::SubTotals, 2, "Jones", 4, ">2010-01-01")

I have a basic sheet with 1.1 million rows of data in four columns, so I can't use Libre Office to filter it (will likely cut it in half and then rejoin it). I need to filter it down so that only values >0 in columns C and D are retained.

Re: Filter function

PostPosted: Wed Apr 27, 2016 8:50 pm
by citadel5
You're right: using pivot tables for filtering purposes isn't the best option. Separate, much more versatile filtering will be added in the near future (perhaps before the end of May).
Btw, for strictly tabular data types GS-Base might be more effective (and it offers built-in calculation functions too).

Re: Filter function

PostPosted: Fri Dec 29, 2017 8:31 pm
by Soap

Any progress on this feature? Coming from being an Excel user, really miss this functionality. Thanks

Re: Filter function

PostPosted: Sun Dec 31, 2017 2:49 am
by citadel5
Obviously there is a significant delay but it's still on the to-do list and should be available rather sooner than later.
BTW, recent GS-Calc updates add some new/additional filtering options to pivot tables.