1 of 1 people found this helpful
can you make a calculated field like:
if <parameter>=100 and (category='A' or category='B') then [Category]
elseif <parameter>=214 and (category='A') then [Category]
I don't think you worded your problem very well so this probably isn't the solution you want
How exactly is your filter supposed to work? keep values that are above the parameter? below the parameter? Are you comparing each individual number? the sum for the year? the some over all? the max ever? Let us know and we can probably come up with a solution.
thank you for your response. I will try my best to explain my intention.
What I do:
I sum up the displayed values over the years. 2011: 10+123+14+3+436 and 2012...
If necessary I drill down and e.g. show the sum per categroy per year.
I am now only interested in data of categories that exceed a certain sum of "filter value" (e.g., 100) in year 2013.
To dynamically filter the data, I would like this sum to be defined by a parameter that one can set from 1 to 10000.
If I set the parameter to 100, this should filter out category C from my data. (across all years, even if the sum of filter value is higher than 100 in 2011 or 2012).
However, the sum for category A and B should be calculated for every year, if it exceeds 100 in 2013 (i.a. if the sum in 2011 would be 80, the data should still be displayed because only the sum of 2013 is the filtering criteria)
Hope this helps.
Thank you very much.
Ok, now I think I got it. First, you will need to create a calculation that only looks at values for 2013 (Selected Year Sum). I used a parameter so you could change the year you are comparing but you can just type in 2013 as well. Next you can create a calculation that asks if that sum is greater than the threshold parameter (Filter). I've attached a workbook that demonstrates this.
Let me know if this is what you are looking for.
filter_parameter.twbx 10.2 KB