Expression's value should only take effect with one filter only

[#1]

Hi Experts,

In an application I have different filters but I just want this specific KPI expression to take effect when this filter “FiscalYear” changes elsewise the KPI values shouldn’t take any effect.

Chart Type: KPI 

Expression: Sum(Max1099)

Filter Name in this specific application: FiscalYear

I would want to have an effect on the value of KPI chart (in a sheet), only when there is any selection in :FiscalYear” else no effect should be taken from any other filter(s).

Can somebody please help!

[#2]

Hi Experts,

1. I used this expression: Sum({1}Max1099) (it works fine)  but this expression do not take  effect of any selection filter.
2. For taking effect of just Fiscal Year I modified the expression to: Sum({1<FiscalYear = {'=$(GetFieldSelections(FiscalYear))'} >}>}Max1099) it does not work and returns no value

can somebody help!

[sunny_talwar]

Try this:

Sum({1<FiscalYear = $::FiscalYear>}Max1099)

[#4]

Hi Sunny,

Appreciate your quick & accurate reply. it worked.

A quick question: the way we just engaged one filter i.e. "FiscalYear", can we engage two filter ?

[sunny_talwar]

Sure thing... try this:

Sum({1<FiscalYear = $::FiscalYear, FieldName2 = $::FieldName2>}Max1099)

Continue adding as many field as you would like. To add fields from alternate state, try this:

Sum({1<FiscalYear = $::FiscalYear, FieldName2 = State1::FieldName2, FieldName2 = State2::FieldName2>}Max1099)

[#6]

Great, thanks.