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?
Question
Select specific accounts and create a metric
+12- Employee
Hi,
yes, look into the FILTER modifier:
Then you can just hide the empty rows/columns
+14- Master Helper
Hi
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.
Clement
- Apprentice Author
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.