How to sort in Pivot tables – Dashboard data visualization

Share on facebook
Share on twitter
Share on linkedin
Share on reddit
Share on email

InfoCaptor has powerful visualization engine that does pivot tables just like Microsoft Excel.

The complete visualizer is built on the concept of pivot tables.

When you are displaying a simple table grid, then sorting is very easy to specify. There are only two ways you can sort a column based tabular grid.

Image

 

In a normal grid like above, you sort the columns either ascending or descending.

In a pivot table, the combination of sorting increases and let us illustrate this using following examples

This is a simple pivot with just one dimension in the row bucket

Image

By default it is sorted by descending order on the first metric

When you right click on the metric column, you get 4 different sorting options

Image

The top two options are for column based sorting and the bottom two are for row based sorting.

Sorting “High to Low[column]” gives descending order and vice versa.

The bottom two options by row are not relevant becase we do not have anything in the column bucket yet

Image

Let us move the dimension to the Column bucket

Image

As you notice, the departments are sorted alphabetically. We can change this by right click and then select the sort option.

Image

Another sorting is available on the dimension members. For dimensions only alphabetical sorting is provided.

Image

infocaptor pivot sorting dashboard

Custom Reports and Dashboards

We will build you a set of custom reports and dashboards
Best Offer

The Core Tools

Create dashboard for any Database

Data Visualizer and Dashboard Application
SALE
This is the best dashboard software for its price. One good thing we did was to hire their consulting services to build few dashboard prototypes and provide some quick dashboard training.
- Terry Seal, IL
We evaluated Xcelsius and Qlikview and the cost for organization to implement dashboards was quoted over 10,000 USD. For fraction of the above quoted price, we were able to buy the licenses for the web based dashboard software and get some free training. This is truly a dashboard software for small businesses like us.
IT Manager of a Trucking company, OH