The Silverlight PivotViewer makes it easier to interact with massive amounts of data on the web in ways that are powerful, informative, and valuable. PivotViewer lets us present thousands of things at once and visualize them in a way that exposes value from the group. PivotViewer experiences range in complexity to build. All involve the creation of a collection. PivotViewer is now available for you to begin building and embedding your collections directly onto your webpage.
For this example we need the following things:
Once you have all the things mentioned above, then open Excel and go to "Pivot Collections" tab. Click "New Collection" from the toolbar.
This will open two worksheets:
- Collection Items
- Collection Properties
I have created a new collection of members of the this site with different roles.
Now from the ribbon select "Publish Collection" to view the output in the browser. It will ask to save the collection.
Different outputs are as follows:
Filtering the records based on "Admin".
Viewing the particular record in the collection.