Set analysis by selected values

[Amit_B]

Hi,

I have 2 tables that are not connected but have similar values. For example in the first table there is a 'year' field and in the second table there is a 'byyear' field. How can I make calculations on the second table according to selections of the values ​​in the first table?

Something like that: (I know the formula is wrong, it's just for example)

sum({<byyear={getselectedvalue(year)}>}amount)

Thanks!

[Anil_Babu_Samineni]

@Amit_B Will you be able to change field name from second table with first table like

Load byyear as Year, .....

So that, Year field is common for both table and you can use with Sum(Amount)

[Antoine04]

Hello,

You need to use the P() function.

Like this :

Does it fit you expectation ?

Best Regards,

Antoine L

[Aditya_Chitale]

Try this: 

=sum({<byyear={$(=GetFieldSelections(year))}>}amount)

Regards,

Aditya

[Amit_B]

I select values in 'year' field and need the 'byyear' field to be updated, so I wrote it like this:

sum({<byyear=P(year)>}amount

When I check it with filter panes it works, but in the kpi (set analysis formula) I get 0.

[Antoine04]

Something like this maybe ? Is that what you want ?

[Chanty4u]

Try this

Create variable

vSelectedYear  =GetFieldSelections(year)

Use below 

sum({<byyear={"$(=vSelectedYear)"}>} amount)