Skip to main content
Question

Select specific accounts and create a metric

  • July 24, 2025
  • 3 replies
  • 101 views

Chris Montiel
Apprentice Author

Hi All, hoping you can help me here … I need to create a metric using just 3 accounts of the GL, I know I can use the filter option but this doesn't work as I need to sum this metric total to other totals from different metrics. Is there a way to pull my GL Actuals asking Pigment to exclude everything but these 3 accounts? 

3 replies

Nathan
Employee
Forum|alt.badge.img+12
  • Employee
  • July 25, 2025

Hi,

yes, look into the FILTER modifier: 

 

Then you can just hide the empty rows/columns

 


CDALMAY
Master Helper
Forum|alt.badge.img+14
  • Master Helper
  • July 25, 2025

Hi ​@Chris Montiel,

You can also use the SELECT modifier :
 

It will look like this

 [SELECT: Account in (Account.”GL1”, Account.”GL2”,Account.”GL3”)]

or

 [SELECT: Account.BooleanProperty]

Where BooleanProperty is a property from the account dimension where you select only the account you want to keep. I would recommend the second option as it’s more scalable.

With the SELECT modifier you will filter and remove the GL dimension and keep only the total.

Hope this helps.


Chris Montiel
Apprentice Author
  • Author
  • Apprentice Author
  • July 28, 2025

Thanks guys for the help, I applied both responses for different parts of my table & now is working as expected 💪🏽🤓

Have a great week!!

Chris M.