This project has moved and is read-only. For the latest updates, please go here.

Pivot Table Top Ten

May 21, 2014 at 10:41 PM
I am having trouble figuring out if the "Top Ten" filter is supported for Pivot Tables.

Would you please let me know if it is supported and if yes supply an example.

Thanks...
Jun 25, 2014 at 2:53 PM
In the currently released version 3.1 the pivot table filter fields is extremely limited (Page Field). This is because it does not load any of the data into the pivot table xml files and lets Excel handle this when the file is opened for the first time. Implementing anything like a "Top Ten" filter requires it to know what the data is in the row or data fields.

I have not seen any indication this is changing in 4.0, but I could be mistaken.

To add something like this it will require some redesign of the source code.