How can I create a pivot table (or crosstab) in InfoView or Webi?

You can arrange data in a pivot table format (also known as a crosstab) using either InfoView or Webi.

To see how to do this in Webi, click here.

In InfoView, you have a couple choices: 

  1. If you have the table existing already, with all the elements you need, right click on it, pick Turn Table to… and then Crosstab

  2. If the columns then aren’t in the order you want then you can use the right click menu options to Swap axis, or Format… Table.. and then use the Pivot tab to rearrange things.

  3. Alternatively, in InfoView, start with a blank tab, use the templates pane to drag a blank cross tab into it, and then drag the objects you want into that.