meta data for this page

Pivot Table

This is the N4V FOR WEBI Wiki page for the Pivot Table widget.

Updated for N4V 2024.2.0

Render

Description

  • Present informations in a pivot table.
  • From 2 to 20 dimensions and from 1 to 20 measures.
  • Ability to change objects in columns/rows, render and calculations dynamically
  • Ability to filter all the fields dynamically. All filters are applied to the table even if corresponding objects are not rendered in the table

Parameters

  • Dimensions 2 to 20 :Choose here the dimensions to use in the table.
  • Measures 1 to 20 :Choose here the measures to use in the table.

Animations

  • Play with objects on rows/columns
  • Change the render of the chart (table, heatmap, charts…)
  • Use the filters in each object to filter the values.

Settings

Here you can find instructions for accessing settings for Need4viz graphics: Format Custom Element.

For the pivot table, the available parameters are :

Extended parameters

  • Global → See the user guide for the “Global” section here
  • Menu → See the user guide for the “Menu” section here
  • UI
    • Hide all UI : This setting allows you to hide all the UI, only the table will be visible.
    • Hide partial UI : This setting allows you to hide parts of the UI. You can hide renderer and/or aggregator selectors and unused objects zone.
    • Hide objects : This setting allows you to hide the measure objects on the objects bar (measure objects will stay visible in the list of value under the aggregator selector).You can also hide dimension objects from the aggregation selector list.
    • Position of unused objects zone : You can enforce the position of the object bar (automatic = depending on the number of objects in the bar, the bar will be placed on top or on the left of the pivot table).
    • Toolbars styles : This setting allows you to change colors and fonts of the toolbars components.
    • Drill data : Display the details data of a corresponding cell (by clicking on the cell)
  • Sort
    • Sort dimensions : native Webi sorting may not be applied correctly in the component. You should define here the sorting you want for each dimension.
  • Styles
    • Headers table style : This setting allows you to change colors and font of the headers. You can also wrap headers labels.
    • Data table style: This setting allows you to change the colors and the font used in the data (detail) cells.
  • Totals
    • Grand total rows options : You can hide the grand total column for the rows.
    • Grand total columns options : You can hide the grand total row for the columns.
    • Grand total header : Change here the labels of grand total headers (by default : “Total”).
    • Grand total rows header style : This setting allows you to change the colors and the font used in the total row header.
    • Grand total rows values style : This setting allows you to change the colors and the font used in the total row values.
    • Grand total columns header style : This setting allows you to change the colors and the font used in the total columns header.
    • Grand total columns values style : This setting allows you to change the colors and the font used in the total columns values.
    • Grand total cross cell value style: This setting allows you to change the colors and the font used in the grand total cross cell value.
  • Table_Subtotals
    • Subtotals rows option : This setting allows you to define the position of rows subtotals in the table.
    • Subtotals rows collapse/expand : This setting allows you to define collapse of rows.
    • Subtotals columns option : This setting allows you to hide subtotals columns in the table.
    • Subtotals columns collapse/expand : This setting allows you to define collapse of columns.
    • Subtotals rows header style : This setting allows you to change the colors and the font used in the subtotals row header. You can also change the labels of the subtotals headers (by default : aggregator + path of dimensions).
    • Subtotals rows values style : This setting allows you to change the colors and the font used in the subtotals row values.
    • Subtotals columns header style : This setting allows you to change the colors and the font used in the subtotals columns header. You can also change the labels of the subtotals headers (by default : aggregator + path of dimensions).
    • Subtotals columns values style : This setting allows you to change the colors and the font used in the subtotals columns values.
    • Subtotals cross cell value style: This setting allows you to change the colors and the font used in the subtotals cross cell values.
  • Renderers
    • Default renderer : This setting allows you to set the default renderer when opening the chart.
    • Renderers to not display in the list : By default, all renderers are displayed in the list. You can set here wich renderers to not display.
  • Aggregators
    • Default aggregation : This setting allows you to set the default aggregation used when opening the chart.
    • Aggregations to not display in the list : By default, all aggregations functions are displayed in the list. You can set here wich function to not display.
  • Init_display
    • Objects index to display initially on rows : By default, the first dimension is displayed as row in the table. You can set here the index of objects to initially set as rows.
    • Objects index to display initially on columns : By default, the second dimension is displayed as column in the table. You can set here the index of objects to initially set as columns.
    • Object index to display initially in calculation : By default, the first measure is choosen as calculation in the table. You can set here the index of measure to initially choose.
  • Heatmap
    • Min value color: Define here the color for the min value when displaying tables in heatmap.
    • Max value color: Define here the color for the max value when displaying tables in heatmap.
    • Intermediate value color: Define here the optional color for the intermediate value when displaying tables in heatmap. The intermediate value is by default the average of the table (do not enter a value in this case).
  • Charts
    • Table Bar Chart options : set here the height of the cells for the table bar chart and the colors for positive and negative values.
    • Charts toolbar options : Set here the toolbar layout (display, color, position) of the charts
    • Charts backgrounds : You can define here the color of the backgrounds of the charts
    • Chart title : Overload here the title of the charts and set the font style.
    • Chart labels : The values labels format (standard - e.g.: 2,345.67, compact - e.g.: 2.3K or compact long - e.g.: 2.3 thousand) can be defined. You can also define the value/percentage you want to display on pie charts.
    • X Axis : Overload here the title of the X axis and set the font style.
    • Y Axis : Overload here the title of the Y axis and set the font style.
    • Charts legend : Define here the legend layout (display, position) of the charts
  • Measure
    • Options measure : This setting allows you to define the precision and unit of measure in the table (only one unit can be applied to the all table). The measurement display format (standard - e.g.: 2,345.67, compact - e.g.: 2.3K or compact long - e.g.: 2.3 thousand) can also be defined.

Export Server → See the user guide for the “Export Server” section here

Export FTP → See the user guide for the “Export FTP” section here

Export SharePoint → See the user guide for the “Export SharePoint” section here