Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
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.
where should i write the first expression?
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
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
thanks, it did work!!
It is working in my app...
However, I'm happy you've found your solution, bye.