Filters on years

[Stefan564]

Don't know if this is the right place to ask this, but i have a question about my filter. i have 2 different tabels in a dashboard that sort on year, my filter only works for 1 dataset, is there a way i can make it work for both?

If this is not the place to ask this, could you point me to the right direction?

Thanks in advance!

this is the filter with the code

And i want it to also work on 

[marcus_sommer]

You could reference a selection-state within an expression, for example:

sum({< Year2 = p(Year1) >} Value)

[BrandonFontes]

Existem algumas formas:

1. Relacionar as tabelas para que funcione os filtros. Ou seja, você filtra uma tabela e ela relaciona na outra.
2. Criar uma LinkTable para relacionar as tabelas e usar o calendário para poder filtrar ambas as tabelas
3. Usar no objeto que você queira interagir o SetAnalysis para corresponder o filtro de ambas as tabelas.
   1. Usar o filtro da Tabela 1 onde tem o campo Ano1
   2. Tabela 1: Sum({< Year1 = p(Ano1) >} Value)
   3. Tabela 2: Sum({< Year2 = p(Ano1) >} Value2)