JavaScript/HTML5 equivalent of Microsoft Pivot?

If you're trying to visualize the sorting and filtering of images like in a couple of the demos then try out isotope.js. It supports sorting, and filtering on multiple categories. The documentation is good and its flexible to what types of HTML elements you use.

If your trying to make a chart Protivis is one of the most full featured visualization libraries I've come across. It would be helpful to know exactly what kind of data your trying to represent. Either way I hope this helps.

You can try icCube Javascript Pivot table, it's dedicated to OLAP Servers.

how about an html5 lib? ZingChart

Some of my coworkers have been using RGraph and are very happy with it. It's only a graphing library though, so it's probably not a full solution to your problem.

Examples

Try out Flexmonster Pivot - web-based component for Pivot Reports. It uses Flash for performance which Javascript impossible to provide (it just crashes), so up to 100mb of data or millions of records are supported.

You could try the jit and Flot

JIT is great especially if you need tree representations. Check out their hyperbolic trees module.

Highcharts is excellent. It looks great (check out the website for images), and it

• Supports lots of chart types, and you can combine them in one graph.
• Easy to configure and use, using plain JSON.
• It's smart about dates on x-axis, marking start of day/month/year automatically.
• Animate in response to events in the graphs.
• Built in zooming in a graph.
• Compatible with all modern browsers, including IE6+ and iPad/iPhone.

And it's free for non-commercial uses.

We've just released a pivot-table javascript with teechart charting, free for non-commercial use.

It takes any json-valid data or javascript object array(s) as input, and allows querying by "dimensions" and "metrics" (ie: group-by, measures, sorting, filtering, etc).

Tee.Data.js: Tutorial and examples

TeeChart.js demos