Filter dimensions so they are not displayed in my table

[Nemo1]

Hello everyone,

I have two questions: 

1 - 

So I have a table, that is showing different countries in europe and their respective population.

One of the columns in my dataset is Country, and there I have all european countries. However, I would like to leave some countries out, I do not need them in my table.. 

how can i do that?

2 - The Totals are shown on top of my table, I would like to have them displayed on the bottom of it. How do i do trhat?

thanks in advance!

[BrunPierre · Accepted solution]

Use this while suppressing Null in dimension.

1. =Aggr(Only({$<Country-={"CountryToIgnore","CountryToIgnore"}>} Country), Country)

2. On the property panel of the table object, go to the Presentation, under Totals, and select Bottom.

[Nemo1]

where should i write the first expression?

[F_B]

Hi @Nemo1 

For your first question you can use set analysis:

write in your Country column expression  =Only( {<Country -= {'A','B','C'}>} Country)

with Country as the field name and A B C the country names you don't want to show

[Nemo1]

i do not get any error when i write that formula but it is still displaying countries A, B and c... and they are correctly written 

[Nemo1]

thanks, it did work!! 

[F_B]

It is working in my app...

However, I'm happy you've found your solution, bye.