Skip to main content
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
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.

Reply