Veja se ajuda
Total =
IF ( ISINSCOPE ( Tabela[State] ), "", SUM ( Tabela[Valor] ) )
------------------------------
Vilmar Santos
------------------------------
Original Message:
Sent: Dec 28, 2022 10:26 AM
From: Lucas A
Subject: Hide last level values from matrix table
Hi everyone,
I have a matrix table that l need to hide the value of last level.
Someone can help me with this?
This is how my data looks like:
| Continent | Country | State | Total |
| North America | USA | NewYork | 25 |
| North America | USA | Texas | 25 |
| North America | USA | Florida | 25 |
| North America | USA | Virginia | 25 |
| North America | Canada | British Columbia | 15 |
| Asia | India | Andhra Pradesh | 20 |
| Asia | India | Tamil Nadu | 20 |
| Asia | India | Karnataka | 20 |
| South America | Brasil | São Paulo | 30 |
My expecteds outputs: I want to show the output in Matrix table 3 levels (Continent, Country and State) sales. But I only want to see total in Continent and Country Level but if expand to State it should be blank as mentioned below.
-At Country Level:
| Continent | Total |
| North America | 115 |
| Asia | 60 |
| South America | 30 |
-After expand to country level:
| Country | Total |
| North America | 115 |
| USA | 100 |
| Canada | 15 |
| Asia | 60 |
| India | 60 |
| South America | 30 |
| Brasil | 30 |
-After expand to state level:
| Continent | Total |
| North America | 115 |
| USA | 100 |
| NewYork | |
| Texas | |
| Florida | |
| Virginia | |
| Canada | 15 |
| British Columbia | |
| Asia | 60 |
| India | 60 |
| Andhra Pradesh | |
| Tamil Nadu | |
| Karnataka | |
| South America | 30 |
| Brasil | 30 |
| São Paulo | |
Thanks,
Lucas
------------------------------
Lucas A
------------------------------