Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Ronald
Contributor III
Contributor III

Grouping Dimension

I´ve created dimension and show QTR0 and QTR-1:

=if(match(Mes,'M60','M59','M58'),'QTR0',
if(match(Mes,'M59','M58','M57'),'QTR0-1'
))

the sum of QTR0 is correct, but QTR-1 don´t sum M59 and M58, because is in QTR0.

Labels (1)
0 Replies