Inforiver
Premium Table
Premium Table
  • Introduction to Premium Table
    • Get Started
      • Installing from AppSource
      • Installing Inforiver for your organization (Org visual)
      • Inforiver Writeback Matrix pre-requisites
        • Whitelist Inforiver IPs
        • Admin consent for Inforiver's Entra ID
          • Basic consent
          • Full admin consent
      • Inforiver Customer Portal
        • Billing Admin
          • Update Profile
          • Update Subscriptions
        • License Admin
      • Licensing
        • License renewal
      • Registering Inforiver on Azure AD (Entra ID)
  • Working with Premium Table
    • 1. Build your first Inforiver Table report
    • 2. Displaying information
      • Report interface
      • Templates
      • Basic formatting
        • Number formatting
        • Cell, header & value formatting
        • Totals & subtotals
        • Insert blank rows
      • Basic inline charts
    • 3. Basic interactions
      • Explore & filter data
        • Search & Filter
        • Explorer
        • Top N + others
      • Sort & reorder data
      • Show/hide values
      • Manage column widths
      • Manage hierarchies
      • Create visual hierarchies
      • Pin rows & columns
      • Blend measures
      • Dynamic measure headers
      • Context menus
        • Column gripper
        • Row gripper
      • Actions
        • Rails
        • Toolbar options
        • Keyboard shortcuts
        • Reset
    • 4. Adding business logic and formulae
      • Insert calculated rows
        • Template rows
      • Insert calculated columns
      • Insert manual input rows
      • Insert manual input columns
        • Number
        • Dropdown
          • Dropdown options from semantic models
          • Lookup visuals for dropdowns
        • Text, checkbox & date
        • Writeback Matrix features
        • Importing data
      • Invert sign
      • Editing cells
      • Quick formula
      • Visual column inside visual measures
      • Manage inserted rows
      • Manage inserted measures & columns
      • Pivot data
      • Insert image URLs
    • 6. Working with charts
      • Sparkline charts
      • Stacked charts
      • Bullet charts and clustered bar charts
      • Waterfall charts
      • Bar and pin charts
      • Change/deviation charts
    • 5. Conditional formatting
      • One-click options
      • Create rule
        • Rules (If conditions)
        • Color scale & data bars
        • Classification
        • Ranking
      • Manage rules
    • 7. Planning, budgeting & forecasting
      • What-if analysis & simulations
      • Goal Seek
      • Budgeting & allocations
      • Set version
    • 8. Paginated reporting
      • Pagination
      • Header & footer
        • Text
        • Images
        • Charts
        • KPI cards
      • Report layouts (Report+)
      • Display and themes
    • 10. Exporting reports
      • Export to PDF & Excel
        • Excel export - operational boundaries
      • Ad hoc emails
    • 11. Scheduling reports
      • Create new subscription
        • Select a report
        • Set subscription frequency
        • Select destination(s)
          • Email
          • OneDrive
          • Microsoft Teams
          • SharePoint
        • Review & save subscription
      • Manage your subscriptions
      • Administration
    • 12. Data writeback
      • Settings
        • General Settings
        • Data Settings
        • Destination Settings
        • Writeback security settings
        • Writeback time-out & batch size settings
        • Advanced Settings
      • Destinations
        • Azure SQL (Managed DB)
        • Azure SQL
        • Microsoft SQL Server
        • Synapse Dedicated SQL Pool
        • Azure Data Lake Storage
        • Databricks
        • Snowflake
          • Setting up Snowflake OAuth
        • Amazon Redshift
        • BigQuery
        • SingleStore
        • SAP HANA
        • Oracle
        • PostgreSQL
        • MySQL
        • OneDrive
        • SharePoint
        • Dataverse
        • Fabric Warehouse
        • Fabric lakehouse
        • Fabric SQL
        • URL as destination
      • Logs
      • Reading mode
    • 14. Manage aggregation
      • Row aggregation
      • Column aggregation
    • 18. Variables
      • Variable types
        • Number
        • Select
        • Text
        • Date
        • Date range
        • Boolean
        • Button
      • Variable bookmarks
  • Admin Console
    • Manage Profile
    • User management
      • User Roles and Permissions
      • Create custom roles and policies
    • Settings
      • General
      • Generate builds - on prem
      • Forecast
      • Holidays
      • API token
      • Writeback
      • Managed DB
      • Assets
    • Onboarding actions
    • Writeback
  • Display settings
    • General settings
    • Hierarchy settings
    • Number settings
    • Miscellaneous settings
    • On-load scripting
  • Formula syntax
    • Conditional statements
      • IF
      • IFNA
      • SWITCH
      • FILTERIF
    • Logical functions
      • AND
      • IN
      • ISBLANK
      • ISEMPTY
      • ISNUMBER
      • NOT
      • OR
      • XOR
    • Math functions
      • ABS
      • AVERAGE
      • AVERAGEEXNEG
      • AVERAGEEXZERO
      • AVERAGEEXZERONEG
      • AVERAGEIF
      • CEILING
      • COUNT
      • COUNTIF
      • DIVIDE
      • EVEN
      • EXP
      • FLOOR
      • INDEXOF
      • LOG
      • ODD
      • MAX
      • MIN
      • NORMDIST
      • NORMSDIST
      • NORMINV
      • NORMSINV
      • PCT
      • POWER
      • RAND
      • RANDBETWEEN
      • ROUND
      • ROUNDDOWN
      • ROUNDUP
      • MROUND
      • SORT
      • SQRT
      • SUM
      • PMT
    • Text formatting functions
      • CONCATENATE
      • HYPERLINK
      • LEFT
      • LOWER
      • MID
      • PROPER
      • REPLACE
      • REPT
      • RIGHT
      • TEXT
      • TRIM
      • UPPER
      • VALUE
    • Date functions
      • DATEADD
      • DATEDIFF
      • DAY
      • DATE
      • DATE.SET
      • DATE.FORMAT
      • SOWEEK
      • SOMONTH
      • SOQTR
      • SOYEAR
      • EOWEEK
      • EOMONTH
      • EOQTR
      • EOYEAR
      • NETWORKDAYS
      • ADDDAYS
      • ADDWEEKS
      • ADDMONTHS
      • ADDQTRS
      • ADDYEARS
      • FROMEXCELDATE
      • MONTH
      • NOW
      • PERIOD_RANGE
      • TODAY
      • TOEXCELDATE
      • YEAR
    • Time intelligence functions
      • AGGREGATE
      • FILTER
      • COLUMN_PERIOD
      • LASTNDAY
      • LASTNMONTH
      • LASTNQTR
      • LASTNYEAR
      • MONTHPERIOD
      • MOVINGAVERAGE
      • MOVINGSUM
      • MTD
      • NEXTNDAY
      • NEXTNMONTH
      • NEXTNQTR
      • NEXTNYEAR
      • QTD
      • QTRPERIOD
      • SHIFT
      • TOTALYTD
      • TOTALQTD
      • TOTALMTD
      • VALUEAT
      • YEARPERIOD
      • YTD
    • Other operators
    • Identifiers
      • CLOSEDPERIOD
      • COLUMN.DATE
      • COLUMN.PARENT
      • COLUMNS
      • CURRENT_PERIOD
      • DESCENDANTS
      • FORECAST.CLOSED_END
      • FORECAST.CLOSED_START
      • FORECAST.OPEN_END
      • FORECAST.OPEN_START
      • GROUP INDEX
      • HAS
      • HAS_ALL
      • HAS_SOME
      • LEAVES
      • LEVEL
      • LOGGEDIN_EMAIL
      • LOGGEDIN_NAME
      • MATCH
      • MAXDATE
      • MEMBERS
      • MINDATE
      • RELATIVE
      • RELATIVE_COLUMN
      • ROW.PARENT
      • ROW.LABEL
    • Scripting functions
      • DISPLAYTOAST
      • EXPORT
      • LAYOUT
      • SETCFRULE
      • SETFILTER
      • SETFILTERBYINDEX
      • SETVISIBILITY
      • SHOWBETWEENPERIOD
      • SHOWCLOSEDFORECAST
      • TOPN
      • DISPLAY SETTINGS
        • SETBLANKLABEL
        • SETSUPPRESSZEROS
        • SETRAGGEDHIERARCHY
        • SEPARATOR
        • SETCOMBINECOLUMNHEADER
        • SEMANTICFORMAT
        • SHOWNULLAS
        • SHOWZEROAS
        • SINGLECHILD
    • Statistical Functions
      • RANK
      • RANKEQ
      • RANKAVG
    • Miscellaneous functions
      • FETCH
      • LOOKUP
    • Measure/Column selection functions
      • GETCOLBETWEENPERIODS
      • GETMEASURE
  • Advanced topics
    • Audit log
    • Backup & restore report config
    • Enterprise themes
    • PowerPoint integration
    • Drill down and roll up in performance mode
  • Accessibility shortcut keys
Powered by GitBook
On this page
  • 1. LAYOUT.HIERARCHICAL
  • Syntax
  • 2. LAYOUT.OUTLINE
  • Syntax
  • 3. LAYOUT.TABLE
  • Syntax
  • 4. LAYOUT.STEPPED
  • Syntax
  • 5. LAYOUT.DRILLDOWN
  • Syntax
  • 6. LAYOUT.LIGHTTHEME
  • Syntax
  • 7. LAYOUT.DARKTHEME
  • Syntax
  • 8. LAYOUT.AUTOFIT
  • Syntax
  • 9. LAYOUT.SETRULER
  • Syntax
  • 10. LAYOUT.GOTOCOLUMNLEVEL
  • Syntax
  • 11. LAYOUT.GOTOROWLEVEL
  • Syntax
  1. Formula syntax
  2. Scripting functions

LAYOUT

Layout functions can be used to set the layout, set a theme, enable/disable rails, or expand the hierarchy to a particular level. Let's take a look at the various options.

NAME
DESCRIPTION

Sets the layout to hierarchy

Sets the layout to outline

Sets the layout to table

Sets the layout to stepped

Sets the layout to drilldown

Applies a light canvas

Applies a dark canvas

Fits the maximum possible data in the available space

Enable or disable the ruler

Expands the column hierarchy to the specified level

Expands the row hierarchy to the specified level

1. LAYOUT.HIERARCHICAL

Sets the layout option to hierarchy and displays the data in a hierarchical format.

Syntax

LAYOUT.HIERARCHICAL

2. LAYOUT.OUTLINE

Sets the layout option to outline.

Syntax

LAYOUT.OUTLINE

3. LAYOUT.TABLE

Sets the layout option to table.

Syntax

LAYOUT.TABLE

4. LAYOUT.STEPPED

Sets the layout option to stepped.

Syntax

LAYOUT.STEPPED

5. LAYOUT.DRILLDOWN

Sets the layout option to drilldown.

Syntax

LAYOUT.DRILLDOWN

6. LAYOUT.LIGHTTHEME

Sets a light background for the canvas.

Syntax

LAYOUT.LIGHTTHEME

7. LAYOUT.DARKTHEME

Sets a light background for the canvas.

Syntax

LAYOUT.DARKTHEME

8. LAYOUT.AUTOFIT

Fits the maximum possible data in the available space.

Syntax

LAYOUT.AUTOFIT

9. LAYOUT.SETRULER

Fits the maximum possible data in the available space.

Syntax

LAYOUT.SETRULER(TRUE) #Enables the ruler
LAYOUT.SETRULER(FALSE) #Disables the ruler
LAYOUT.SETRULER(THIS) #Control the 'THIS' parameter using a toggle variable button

10. LAYOUT.GOTOCOLUMNLEVEL

Expands the column hierarchy to the specified level. The highest level of the hierarchy is denoted by '0'.

Syntax

LAYOUT.GOTOCOLUMNLEVEL(1) #Expands to the second level of the column hierarchy
LAYOUT.GOTOCOLUMNLEVEL(THIS) #Expands to the specified level which can be set using a numerical stepper variable

11. LAYOUT.GOTOROWLEVEL

Expands the row hierarchy to the specified level. The highest level of the hierarchy is denoted by '0'.

Syntax

LAYOUT.GOTOROWLEVEL(2) #Expands to the third level of the column hierarchy
LAYOUT.GOTOROWLEVEL(THIS) #Expands to the specified level which can be set using a numerical stepper variable

PreviousEXPORTNextSETCFRULE

LAYOUT.HIERARCHY
LAYOUT.OUTLINE
LAYOUT.TABLE
LAYOUT.STEPPED
LAYOUT.DRILLDOWN
LAYOUT.LIGHTTHEME
LAYOUT.DARKTHEME
LAYOUT.AUTOFIT
LAYOUT.SETRULER
LAYOUT.GOTOCOLUMNLEVEL
LAYOUT.GOTOROWLEVEL
Layout hierarchical
Setting the layout to outline
Setting the layout to table
Setting the layout to stepped
Setting the layout to drilldown
Setting a light canvas
Setting a dark background
Autofit layout
Ruler enabled using set ruler
Expanding the column hierarchy
Expanded row hierarchy