Sum by Year

[Anonymous]

I want to show sum by all year and doesn't change on user selection

[dwforest]

use Set Analysis

Sum({1<Year={'2018'}>} Amount)

[balabhaskarqlik]

On Irrespective of Selection:

=Sum({1<Year = {'2018'}>}Sales)

On excluding current selections:

=Sum({1-$<Year = {'2018'}>}Sales)

on all years:

=Sum({<Year = >}Sales).

[ramkrishna86 · Accepted solution]

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