Best pivot software for free download

Tables Transformer for Excel 2000-2007 will allow you to fast and easy transform current tables to construct pivot ones; to divide one table into several ones or to unite two tables in one.
Data transformations for the construction of pivot tables: Microsoft Excel has a powerful and convenient means of data presentation in the form of pivot tables. However, additional transformations of initial tables are often necessary for their creation. Tables Transformer for Excel will transform initial data and will make it suitable for the construction of the pivot tables.
Division of tables: Tables Transformer for Excel will divide the specified table into several ones on the basis of the specified number of rows or unique values of cells in the specified columns. To divide the current table into several ones on the basis of the specified number of rows, you have to specify the number of the row from which a new table starts - and the table will be immediately divided. The program can automatically copy names of columns in each new table and place new tables in the current or new worksheet. The option of dividing the table according to unique values will allow you to create separate tables for each unique value of a cell.
Merging two tables in one: Tables Transformer for Excel will unite two tables in one with grouping of this data. For example, you have a table with names of the goods and their quantity and the other one containing the name of the goods, delivery date, supplier and price. Using this option, you can unite these 2 tables grouped according to the names of the goods. In the result, you will get a table containing 5 columns: name, delivery date, supplier and price. This option also allows you to choose the data to be included into a new table as well as to choose an arrangement of the new table. All the data remains unchanged.

Related software: excel, xls, format, worksheet, multiple, workbooks, add, sheet, microsoft, download, 2003, combine, cells, 2007, worksheets, 2000, spreadsheet, ins, merge, tables, tips, xlsx, sheets, plugin, plug, pivot, format worksheet, multiple workbooks, excel add-in, format sheet, microsoft excel, excel download, excel 2003, combine cells, excel 2007, ms excel, excel 2000, spreadsheet format, excel add ins, merge tables, excel tips, excel add-on, multiple sheets, excel plugin, combine tables, excel plug-in, pivot tables, …

RadarCube is a powerful NET Windows Forms OLAP control entirely authored in C# 2.0. Having an excellent performance it allows to work with databases with millions records. RadarCube has a splendid user interface and powerful API designed to create true OLAP applications.

Key features:
- One or several tables/views /stored procedures described in a DataSet object.
- A set of standard aggregation functions like Sum, Count, Distinct Count, Min, Max so on. Custom aggregation functions.
- Hierarchies of three types:
-- Parent-child hierarchies (both balanced and unbalanced);
-- Multilevel hierarchies (both regular and ragged);
-- Mixed from all previous types.
- An ability to create calculated measures, dimensions, hierarchies and hierarchy levels.
- Calculated members of hierarchies.
- Auto conversion of the DateTime fields into multilevel hierarchies. Any conversion algorithms.
- Unicode support.
- Several types of drilling down: to the nearest successor, to the next level, to the next hierarchy.
- Hierarchy members grouping (including multilevel and parent-child hierarchies).
- Separate sorting of different hierarchy levels.
- Ascending or descending sorting based on the column values in the grid.
- Filtering of hierarchy members with or without applying these filters to the OLAP calculations.
- Ability to place pictures into grid cells, and automatically position picture and text within the cell, depending on the parameters defined by a programmer.
- A complete control over the cells contents, ability of custom drawing within the cells.
- Ability to change the context menus in the grid.
- Auto sizing of the cell depending on their contents.
- The IListSource interface implementation which allows OLAP Grid to be used as the data source for the components working with data (for example, Chart or export).
- Allows exporting grid data to MS Excel, BMP, TXT, HTML, JPG, GIF, PDF, and so on.
- An ability to edit OLAP data.

Related software: olap, pivot, windows, forms, business, intelligence, owc, cube, crosstab, windows forms, business intelligence, …

HierCube Library is a set of VCL components designed to create fast, handy, and powerful OLAP-applications in different IDE. The library has its own OLAP-engine made using MOLAP-principle, and allows you making OLAP-views "on the fly", not wasting time and memory for intermediate calculations. Calculations performance doesn't depend on the cube capacity and the depth of hierarchical dimensions. For example, one million records fact table is processed for less than a second. No OLAP server required.
Main features:
- 100% Unicode support
- "Star" or "Snowflake" schemas support
- Hierarchical dimensions of any nesting level, defined with "Parent-Child" relations
- Several flat dimensions grouped into a hierarchical one (composite or multilevel dimension).
- Dimension filters: allows to exclude any members from the current OLAP-view
- Dimension groups: allows to gather any members into a single group during.
- History of OLAP-views: allows "undo", "redo" operations during OLAP-analysis
- Three types of calculated summaries: see data that you really want.
- Different aggregate functions and sub-functions: using different functions to display cube data. Sub-functions display the final result in different ways like displaying % value instead of the function value.
- Supersaturated cubes: no need to group records in the SQL-queries.
- Saving/Restoring: allows to save all cube and/or all OLAP-views in a disk file and restore it back later on.
- Fact table editing: allows to use HierCube library to create cross tabulated tables.
- Displaying current OLAP-slice in a diagram.
- Dimension attributes: displaying additional information given from the dimension table from any member.
- No standard problems of "sparse" multidimensional cubes like "database explosion" or "cube sparsity".
- Vast export functionality: copying to Clipboard, exporting in the most common formats: PDF, RTF, HTML, XLS, CSV, BMP, WMF, and other.
- Easy localization.

Related software: olap, component, engine, grid, application, view, cross, tabulated, table, molap, principle, hiercube, radarsoft, aggregate, server, composite, dimension, multilevel, pivot, olap-component, olap-engine, olap-grid, olap-application, olap-view, cross tabulated table, molap-principle, olap-server, composite dimension, multilevel dimension, …

RadarCube is a fast and powerful ASP.NET OLAP control providing you with a unique chance of supplying the web site with the MS Analysis 2000 or 2005 client abilities. It is entirely authored in C# 2.0 and can be an excellent substitute for the OWC PivotTable control.
The main features are:
- Royalty free!
- 100% managed (C# 2.0), no ActiveX code
- All ASP.NET 2.0 advantages. 100% AJAX
- Supports IE 5.5+, Firefox 1.1+, Opera 9.0+
- Supports the Microsoft Analysis Server 2000, 2005 or local cube files using ADOMD.NET 9.0
- Two working modes: cube browsing and displaying the results of any MDX-queries.
- Ability to create additional calculated measures on the client or server side.
- Supports additional calculated members of hierarchies on the client/server side.
- Web parts support
- Drag-n-drop support (all browsers)
- Time intelligence support
- Fixed columns/rows headers on scrolling the grid (all browsers)
- Ability to simultaneously display a set of measures, named sets and KPIs in the Grid.
- Interactive drill-down support of all types of hierarchies separately for every grid cell.
- Saving and restoring the current OLAP slice.
- Member grouping on any hierarchy level without changing the hierarchy levels structure.
- Separate hierarchy or dimension sorting on any level. Ability of any sorting method overriding.
- Ascending or descending sorting based on any column value in the OLAP grid.
- Supports filtering of any set of hierarchy members with or without applying these filters in the OLAP calculations.
- Auto filtering of the hierarchy members depending on their values in the grid. An ability to select some major/minor members, either according to their rank or on the Pareto principle.
- Custom rendering in any grid cell.
- Custom popup menus in the grid (all browsers).
- Handy integration with charting and other third-party components.
- Flexible export to: BMP, CSV, GIF, HTML, JPEG, PDF, PNG, TIFF, TXT, XLS, XML.

Related software: olap, pivot, pivottable, analysis, asp.net, drilling, hierarchy, pivoting, …

Advanced aviation logbook for Windows. Completely customizable, comprehensive reports, interactive charts, custom currencies, powerful data analysis, and free tech support. Try risk free with no time limits. User-defined data fields, track certificates, ratings, medicals, biennials, currency, and more. Pivot-table analysis, exports to RTF, PDF, HTML, Excel...Import any CSV or TAB delmited text data file. Inline web browser, software updater, compliant with Windows XP and all 32-bit Windows Operating Systems. High-speed and completely customizable, Palm and Pocket PC companions!!!

Related software: logbook, pro, palm, pilot, pocket, windows, pda, fly, flight, aviation, log, takeoff, airplane, helicopter, glider, inventory, pim, record, database, private, commercial, airline, logbook pro, palm pilot, pocket pc, windows ce, private pilot, …

One of conditions to achieve success in business is quick data analysis that allows saving money and time. Today many companies use pivot tables which have imperfections such as lack of flexibility and integrity of dataset, intraprocess transparency. Companies should put a question if they are ready to loose competitive ability using inaccurate data or apply progressive technology. For those who are eager to increase the efficiency by applying such a technology Perpetuum Software offers OLAP ModelKit. In addition to common functionality inhered by the existing OLAP components such as accuracy and easiness of data analysis, ability for creating and treating alternative relations etc. OLAP ModelKit has its own particularities. The product is fully compatible with .NET due to 100% managed code. This component has an XP Themed appearance and an ability to use any .NET data sources (including ADO.NET and IList). OLAP ModelKit supports nested data sources. Now there is no need to prepare a special data access meeting the required calculations. This library is intended for creating and utilizing cross reports based on multiple statistical data of large volumes. Moreover, OLAP ModelKit provides an opportunity to represent the final report data not only as a table; it also allows organizing the information so to make it available for use by third party chart components. It should be mentioned such features as comprehensible User Interface. Now end users have an ability of data filtering, drilling down, rolling up, dimensional pivoting, ranking. The product allows embedding OLAP technology in all Windows applications based on relational data. It is possible to export a cross report into an Excel table, HTML or PDF. Please be advised that OLAP ModelKit 3.0 supports only .NET 2.0. If you work with .NET Framework 1.1, please use OLAP ModelKit 2.3 that is compatible with .NET 1.1 and .NET 2.0

Related software: olap, .net, pivot, table, data, cube, analytical, processing, pivot table, data cube, analytical data processing, …

Report Sharp-Shooter is a reporting component that helps you create flexible reports and easily integrate them into your Web and Win apps. It supports a variety of industry-standard export formats including PDF, HTML, Excel, Word, RTF, and more.

An advanced Master Report concept helps to save time while developing a large number of reports with the unified layout. Just create a template containing all recurring elements and use it in further reports design.

Report Sharp-Shooter offers an increased report performance. A built-in pivot table component allows dynamic data analysis and presentation in the form of OLAP reports. And a native charting component allows you to increase the graphical impact of applications with visually appealing charts and graphs.

Report Sharp-Shooter introduces an advanced concept of SideBySide band that allows placing separate report parts in parallel with horizontal shift. An intuitive end-user designer can be used for both report templates and rendered documents. A convenient Report Wizard helps to design any kind of report with a few mouse clicks. Win and Web viewers allow a user to view reports in Windows and Web applications. Give the reports a professional appearance by using a rich visual controls set, including texts, shapes and pictures. You can also use any Win Forms control as a report element. Report rendering is fully customizable thanks to support for C# and VB.NET scripting. There is no need to learn additional script languages. This grants a developer full access to all .NET Framework capabilities such as import of any project namespaces, local variables, procedures etc. Parameterized reports and subreports provide the opportunity to specify the level of detail needed for particular purposes and create a complicated hierarchy of reports.

Be advised that this component version supports only .NET 2.0. If you work with .NET Framework 1.1, please use Report Sharp-Shooter 2.3 which is compatible with .NET 1.1 and 2.0

Related software: .net, reporting, component, report, engine, generator, solution, for, .net reporting component, .net report engine, .net report generator, reporting solution for .net, …

FlexiMIS component compliments the power of SQL and Excel with its own power. It takes the connection string, SQL queries and header string as inputs and generates a properly formated, multi-sheet, interlinked Excel workbook as a report. The report can contain formula, functions, graphs, pivot tables, etc. FlexiMIS can also add subtotals, percentages, etc. You have choice of either seeing the report on screen or saving it to disk or mailing to a pre-specified address (mailing requires a MAPI-compliant email client connectivity). The Multi-Report Mail feature converts the output of a single query into multiple report files and mails them to respective recipients.
Output parameters can be specified through a separate program which is a part of FlexiMIS offer. SQLBuilder.xls - which is a GUI for building SQL and formatting the reports - is intuitive and easy to learn. Use of mnemonic keywords in SQL helps the user to learn and remember the keywords rapidly.
Use of formulas in the report can make the task of complex reporting very simple. For example, if you need to show two distinct and very complex set of numbers against every entry in the first column of the report, then you can just write 3 queries and link their outputs by a simple "VLOOKUP" function in Excel. This keeps the individual queries simple.
FlexiMIS also makes up for the difficulties or lacunae in SQL, like generating a cumulative total or removing duplicates. By using aggregation feature of FlexiMIS, you can just run a query to list out transactions and instead of individual values, you get the running balances directly. Also, calculating the percentage to subtotals can be done by simply inserting a single keyword. Another keyword can remove duplicates and show either first or last entry, as you wish.
FlexiMIS also allows you to pay for use, rather than a one-time license. The license cost is per database rather than one big license fee which can be difficult to absorb on one application.

Related software: mis, component, report, excel, writer, pivot, table, mail, reporting, engine, mis component, report in excel, report-writer, pivot table, report mail, reporting engine, …

Modern businesses are challenged by a host of problems that must be solved immediately or the business won't be a success. One of the most critical problems is the impossibility of making a decision without effectively processed and visually represented information. A complex approach including creation of an effective reporting system, decision support system and real-time data monitoring system is required for the problem solution. .Net ModelKit Suite is a set of components designed for data processing, analysis and visualization. These components allow developers to create sophisticated applications providing immediate decision-making support. With this package you are able to: Use Report Sharp-Shooter: a reporting component for .Net that helps you create flexible and feature-rich reports and easily integrate them into your Web and Windows applications. Create effective visualization applications displaying real-time data with the help of Instrumentation ModelKit. This product includes a rich library of ready-made controls and intuitive graphics editor that allows you to create your own instrumentation controls. Use OLAP ModelKit to perform dynamic data analysis and representation in the form of interactive pivot tables. You can increase the graphical impact of your Win or Web forms apps with visually appealing charts, graphs and digital dashboards designed with the help of Chart ModelKit and the .Net Dashboard Suite. The .NET ModelKit Suite is not simply a pack of individual products. It gives you an interconnected development framework with similar design-time and runtime customization facilities, common data management and appearance customization methods. Please be advised that the .NET ModelKit Suite 3.5 supports only .NET 2.0. If you work with .NET Framework 1.1, please use the .Net ModelKit Suite 2.3 which is compatible with .NET 1.1 and 2.0

Related software: .net, components, suite, winforms, webforms, package, .net components suite, .net components, suite of .net components, .net components package, …