Alternate State? Getfield? How Can I handle this?

[antoniodneto]

Hi Guys,

I'm trying to solve one question.

I have one filter pane called NOME

And one table that shows me GRUPO,NOME and SALES

How can I do to when I select one value on NOME to table shows me all values to NOME on same GRUPO?

A example without filters.

GRUPO                  NOME                

BRASIL                   ANTONIO

BRASIL                  CARLOS

EUA                        JHON

SPAIN                    JAVIER

for example if a choose ANTONIO on NOME the table may shows me all the NOME's values on same GRUPO of ANTONIO

GRUPO                NOME

BRASIL                ANTONIO

BRASIL                CARLOS

That is possible?

Tks guys!!!

[Nicole-Smith · Accepted solution]

For data that looks like this when loaded into the dashboard:

GRUPO	NOME	SALES
BRASIL	ANTONIO	1000
BRASIL	CARLOS	2000
EUA	JHON	3000
SPAIN	JAVIER	4000

Make a table with the following:
Dimension 1: GRUPO
Dimension 2: NOME
Measure: sum({<nome=, grupo="P(GRUPO)">}SALES)</nome=,>

Upon selecting ANTONIO, the table will show:

GRUPO	NOME	sum({<NOME=, GRUPO=P(GRUPO)>}SALES)
BRASIL	ANTONIO	1000
BRASIL	CARLOS	2000

The set analysis in the measure is telling it to ignore the selections in NOME but only show the possible GRUPO for the current selections.

[antoniodneto]

Hi @Nicole-Smith,

It worked pretty fine.

Tks a lot!!!