Discover New Insights with SpreadJS PivotTables
A PivotTable is a powerful data summarizing and reporting tool that allows you to organize, extract and analyze large amounts of data quickly. Improve your business intelligence by visualizing complex data, discover trends, and uncover data information that otherwise may be very difficult to answer by looking at the data itself.
Interactive Data Analysis
With a few lines of code and a couple of clicks in the Designer, reduce hours of work to minutes, decrease the chance of errors caused by manual creation, focus more time interpreting and analyzing data efficiently by letting SpreadJS PivotTables do the work for you.
Create Interactive Dashboards
SpreadJS PivotTables turns reporting pain points into something manageable and provides the information you want, how, and when you want it. Instantly aggregate sales numbers by different fields and filters, providing a concise data view with only a few lines of SpreadJS code.
Income statements, balance sheets, and P&L statements are quick and easy to put together with SpreadJS PivotTables. Emphasize subtotals for-profits, including gross and operating. Summarize large amounts of data with calculated fields for a customized clear and concise table.
Key Performance Indicators
Track company growth, KPIs, and analysis for your data visualization with a table creation that focuses on multiple strategies, variables, inputs, and outputs.
Creating budgets is simple and easy with SpreadJS PivotTables. Use detailed PivotTables to compare budgets, track actual expenses compared to projected values, summarize expenditures for different offices and product lines with a simple drag and drop interface.
Below are some features you can use to implement various use cases, providing unparalleled customization and data analysis.
In a PivotTable, fields are arranged using the PivotTable panel. The arrangement and settings determine the final result of the PivotTable. Choose various fields to add to your report based on the contents of your data source. Simply drag-and-drop the different fields within the panel to customize the control.
The placement and order in each area of a PivotTable's fields affect the overall appearance. Users can drag the field values up or down within the areas to adjust which data appears first in the PivotTable. PivotTables supports Label Filters, Value Filters, Sorting, Group and Collapse functions, and more.
Similar to the base SpreadJS Conditional Formatting implementation, PivotTable also supports conditional rules. These can be set on specific dimensions, and no matter how the layout of the PivotTable is changed, those conditional rules will still be applied to the specified dimensions.
SpreadJS provides a context menu specific to PivotTables, giving your customers full control over different properties of a PivotTable. Control refreshing the PivotTable, removing data, adding summarizing data, change how values are shown, show PivotTable details in a separate sheet, and change the settings of value fields, all with a single right-click in the PivotTable.
SpreadJS Media and Content
Award-Winning Products and First-Class Support
"I have been using a various form of Spread back to the COM days. Spread is the most reliable spreadsheet that retrieves and stores data, whether interacting with a database or simply an Excel file. Try it out, and you will not go back to any other control"
"Great support through evaluation process, Spread is my favorite development add-in, adds great, high value capabilities to applications!"
"Excellent Products. I have been using their products for around 15 years. Always there to help."
MESCIUS Spread is Trusted by the World's Leading Companies
Jan Domanski, Labstep
"We have been using Spread in our desk and web products (PerpetualBudget) for over a decade. Not only are the Spread grids great controls but the support at GrapeCity [now known as MESCIUS] is the best. When you need them, they're there!"
Jim Spicer, Spicer-Baer Associates
"I haven't come across such a feature-rich solid Spread before. Thanks for giving such a nice component."
Adavesh Managaon, MVP, Visual C#
"Spread benefits my company because our clients can now see the immediate benefit the websites we create for them provide."
Michael Stark, Owner, StarkNetwork.com