topic Re: Filter dimensions so they are not displayed in my table in App Development

Filter dimensions so they are not displayed in my table

Nemo1 — Fri, 15 Nov 2024 20:58:58 GMT

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!

Re: Filter dimensions so they are not displayed in my table

BrunPierre — Thu, 02 May 2024 08:21:33 GMT

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.

Re: Filter dimensions so they are not displayed in my table

Nemo1 — Thu, 02 May 2024 08:26:59 GMT

where should i write the first expression?

Re: Filter dimensions so they are not displayed in my table

F_B — Thu, 02 May 2024 08:27:53 GMT

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

Re: Filter dimensions so they are not displayed in my table

Nemo1 — Thu, 02 May 2024 08:38:05 GMT

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

Re: Filter dimensions so they are not displayed in my table

Nemo1 — Thu, 02 May 2024 08:53:05 GMT

thanks, it did work!!

Re: Filter dimensions so they are not displayed in my table

F_B — Thu, 02 May 2024 09:01:13 GMT

It is working in my app...

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