1 Reply Latest reply: Nov 19, 2015 10:54 AM by Sunny Talwar

# how to dynamicaly set filters with a text ?

Hello !

I'm building a simple page with one table and one graph. In this table is one dimension (costpool) and 3 measures

- AmountA : Sum({\$<year={\$(vCurYear)}>} amount)

- AmountB : Sum({\$<year={\$(vCurYear-1)}>} amount)

- Deltavalue:  Sum({\$<year={\$(vCurYear-1)}>} amount) -Sum({\$<year={\$(vCurYear)}>} amount)

the graph is a combo graph with the same information.

Pretty simple as I said.

I want to be able to filter the costpool by showing only those where the DeltaValue is above a value set by a variable vLevel.

The dimension Limit does not work because 1) it works only with the 1st measure. 2) it does not modify the filters (in other words that will not impact the graph)

Is this a way to do that ?

Fred

• ###### Re: how to dynamicaly set filters with a text ?

May be this:

Deltavalue

=If(Sum({\$<year={\$(vCurYear-1)}>} amount) -Sum({\$<year={\$(vCurYear)}>} amount) > vLevel, Sum({\$<year={\$(vCurYear-1)}>} amount) -Sum({\$<year={\$(vCurYear)}>} amount))

AmountA

=If(Sum({\$<year={\$(vCurYear-1)}>} amount) -Sum({\$<year={\$(vCurYear)}>} amount) > vLevel, Sum({\$<year={\$(vCurYear)}>} amount))

AmountB

=If(Sum({\$<year={\$(vCurYear-1)}>} amount) -Sum({\$<year={\$(vCurYear)}>} amount) > vLevel, Sum({\$<year={\$(vCurYear-1)}>} amount))