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
Page 1 / 1
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
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.