Hello, I would like to group in my line chart, for example: Qtr0 = M24 + M23 + M22 ans show %; in the original line chart it shows everything perfectly
But when I group in the dimension it shows nothing.
Dimensions:
/*
=if(Mes='M24'or Mes='M23'or Mes='M22' or Mes='M21' or Mes='M20' or Mes='M19' or Mes ='M18'or Mes ='M17'or //Mes='M16'or Mes='M15'or Mes='M14' or Mes='M13',Mes)
M24='202003' | Qtr0 |
M23='202002' | Qtr0 |
M22='202001' | Qtr0 |
Result when grouping Dimension:
=if(Mes='M24'or Mes='M23'or Mes='M22','Qtr0',
if(Mes='M21' or Mes='M20' or Mes='M19','Qtr-1',
if(Mes='M18' or Mes='M17' or Mes='M16','Qtr-2'
)))
*/