Filters

[Anonymous]

Hello ..

I created several fields that are within the Multiple Selection object where are the fields of Day, Month and Year also a table that brings the total sales.

What I need is that when you filter by year, the table will bring the total sales that year. I am using the expression Sum (Sales). Also if I select another filter more accurate than the sum of sales continue trazenda just the sum of sales of the year.

I managed to make it to work.

Can anyone help?

[danielrozental]

Try

Sum({1<Year=P(Year)>}Sales)

[#3]

You need use set analisys....

something like Sum({1<Year={$(=Only(Ano))}>} Sales)

Em troca....tira esse simbolo dai....rs

[Anonymous · Accepted solution]

Obrigado...Deu certo...

Ainda tem pouca estrela nesse símbolo.

Deixa juntar mais que eu tiro..rsrsrs