Skip to main content

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 !

@msouss is 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 ?'nREMOVE FIRSTNONBLANK: 'macro composant']

or

'MD02 - Quel macro composant ?'nREMOVE LASTNONBLANK: 'macro composant']


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


Reply