Select Total Aggregator

Question

Hello, I have a metric “MD02 - Quel macro composant ?” which displays elements from the list “macro composant” and its total. The dimensions are “Composants” and “macro composants”.  I also have a second metric where I want to display the total with the only dimension “Composants” :  Do you know which formula I must use in this second metric please ?Thank you very much !

oliverlee · Accepted Answer

​@msoussis your Total the first non blank or last non blank?You’d use the same aggregator in your formula, i.e.'MD02 - Quel macro composant ?'[REMOVE FIRSTNONBLANK: 'macro composant']or'MD02 - Quel macro composant ?'[REMOVE LASTNONBLANK: 'macro composant']

msouss · Answer

​@oliverleeit was last non blank and the formula worked perfectly, thank you very much !!

Ask your question here!

Not finding what you're looking for?

Sign up

Single Sign-On Need help?

Log into the Pigment Community

Single Sign-On Need help?

Scanning file for viruses.

This file cannot be downloaded