Filtering Metrics in a Table Block

Hi There!

In Pigment, you can’t “filter metrics to show only totals” within a single Table view, because totals are a display setting and they’re calculated from whatever metrics are included in that view (they aren’t a separate “totals-only” metric filter you can toggle).

Best practice workaround: create 2 saved Views + switch between them from the Board
 

• Create a “Summary / Totals” View
  • Keep only the few KPI metrics you want at summary level (remove the detailed metrics from the view).
  • In the View settings, enable Totals on first row (and/or column totals depending on your layout).
     
• Create a “Detailed” View
  • Include the full metric list and the same pivots/filters you need for analysis.
     
• On the Board, add navigation/buttons to open the table in each View
  • One button/link for Summary
  • One button/link for Detailed

This gives end users a clean “toggle” experience and is usually better for performance than trying to keep everything in one view and hiding/showing items.
 

You may find the link below to our Help Centre a useful resource.

https://kb.pigment.com/docs/customize-layout-views#display-mode

Hi Chris,

Can this be achieved thanks to hierarchy tree views?

Here is a table with 3 metrics using 3 dimensions.

That the summary level, I have only my totals

> Expand by clicking on the + to go more granular

article is here

https://kb.pigment.com/docs/customize-layout-views

Please let me know if this helps.

Thanks