OLAP Table Row exclude

Hi Team,
1-In OLAP TABLE how to Add Grand Total Row with sum of Numeric value.
2- Let Say in Table - I have 5 Rows , and want to exclude 1 Rows .
1- A - 10
2-B -20
3-C-30
4-D-40
5-Null -50

I want Show olap table as below
1- A - 10
2-B -20
3-C-30
4-D-40
Total - 100

image Celonis

Hi @Ajay1998,

welcome to our community!

It is not possible to simply exclude one row. What you could possibly do is to set a component filter on the column containing the values A, B, C, D, NULL. In case you always want to exclude NULL, your component filter looks like this:

FILTER “Table”.“Column Name” != ‘NULL’

Unfortunately, it is currently not possible to add a total row to the table. You could add a ‘Number’ component and sum up your values respectivly.

Best,

Justin

Thanks a Lot Justin for help and clarification. This really help to explain to our Customer.

image001.png