Pivots have been available in products like Microsoft Excel for many years, yet many users do not know what they are, let alone how to use them.
Flexquery finally unleashes the power of pivots in an economic and easy to use way. Want to see department totals in a store sales report? Just drag and drop the department field into the summary row. Want to see sales by vendor by store by month and then by month by vendor by store? Just drag the row fields into the desired order and Flexquery will recalculate right in front of your eyes. Want to see an average rather than a summary total? Or a standard deviation? Just change the data summary type.
And all data by default is shown in the most summarized form possible by default. You can ‘drill down’ to see more summaries as and when you want to. This helps to optimize the time taken to recalculate new totals.
Look at your data from any angle any time. Print just what you need. Export what you need.
Pivots support saved layouts so it is easy to retrieve a previously created layout. Or create a new one, click a button and enter a name. Your work is preserved for future use.