Upcoming webinar on 'Inforiver Charts : The fastest way to deliver stories in Power BI', Aug 29th , Monday, 10.30 AM CST.    Register Now

Manage totals & subtotals in Power BI

by Inforiver | May 27, 2021 | ,

Be it a normal table or a hierarchical matrix style report in Power BI, Inforiver allows you to seamlessly manage subtotals and grand totals in a couple of clicks.

Let us take the case of the following dataset, with hierarchies across both rows & columns.

Dataset with hierarchies

Note that

(a) The row subtotals (Beverages & Water) are the top, and

(b) The column subtotals (International Total & US Total) are at the right

(c) There are no grand totals for rows or columns.

Customizing total and subtotal options

Let us add the grand total for rows & columns. Click on Home --> Total from the menu. A set of options drop down.

Managing totals & subtotals - Total option for grand total of rows and columns

Select ‘Top’ and ‘Right’ as row and column grand total positions… 

Turn on row and column grand total options

… and you would automatically see them reflected in the table.

Grant total gets reflected

You can also change the positions of row & column subtotals or turn them off. 

Position feature Inforiver

There is another final interesting option that we need to try – “Enable row subtotal split”. Let me enable this and disable both the grand totals.

Position feature pop up

Let us now look at Beverages. There is a header row with no values, followed by a set of records. At the end of this section, the records are totaled. This is the ‘split subtotal’ option. We decided to include this option in Inforiver as this format is commonly used in spreadsheets.

Split subtotal option

And finally, the options explored above also allow you to create interesting patterns as shown below – where records are just grouped – with no subtotals. (Hint: Disable split subtotals AND turn off row subtotals).

Records grouped with no subtotals

In summary, Inforiver allows you to manage row & column subtotals & grand totals the way you want in an intuitive & flexible manner. These methods work for both flat tables & hierarchies.

Manage totals & subtotals in Power BI

Learn more about Inforiver's reporting capabilities.

Share this on:

Get Inforiver brochure

Maximize your business potential with Inforiver's paginated reporting, data entry, planning & budgeting capabilities
Download now
About Inforiver!
Inforiver is the fastest way to do everything in Power BI. It enables citizen developer productivity and unleashes true self-service with our intuitive and interactive no-code data app suite for Microsoft Power BI. The product is developed by Lumel Technologies Inc, who are #1 Power BI Visuals AppSource Partner serving over 3,000+ customers worldwide with their xViz, Inforiver, and ValQ offerings.
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram