Dear all,
Currently ARIS Aware / Mashzone NG supports totals or subtotals (on columns and rows) are only supported using RAQLs.
Example sums over organisation
select nvl(Organisation,'Total') Organisation,
sum(CASE WHEN Sparte= 'KFZ' THEN Anzahl_Retourengruende ELSE 0.0 END) as Anzahl_KFZ
,
sum(CASE WHEN Sparte= 'Leben' THEN Anzahl_Retourengruende ELSE 0.0 END) as Anzahl_Leben
,
sum(CASE WHEN Sparte= 'SHU NKS' THEN Anzahl_Retourengruende ELSE 0.0 END) as Anzahl_SHU_NKS
,
sum(CASE WHEN Sparte= 'Unfall' THEN Anzahl_Retourengruende ELSE 0.0 END) as Anzahl_Unfall,
sum (Anzahl_Retourengruende) as Gesamt
from feed1
group by rollup (Organisation)
Please support an easier way without RAQL
Brainstorm ID | 6460 |
Created on Brainstorm | 11/15/2018 06:04 AM |