Skip to main content

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? 

Hi,

yes, look into the FILTER modifier: 

 

Then you can just hide the empty rows/columns

 

Hi ​@Chris Montiel,

You can also use the SELECT modifier :
 

It will look like this

 eSELECT: 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.

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.

Reply


Ask your question here!

Terms & ConditionsCookie settings