Set Analysis - multiple conditions

[#1]

Hello,

I wonder if anyone can help please...

I am trying to use two set analysis in an expression:

They both work separately as expression, however, when I try to combine them they do not both give the desired effect.

I want to be able to fix the bar chart on FY 2015 as well as fixing the bar chart to display all values.

Ie, my bar chart is fixed on FY15 and does not change when months are selected etc.

Many thanks,

[mikecrengland · Accepted solution]

I'm not exactly clear on what you want, but try sum({1<fYear = {2015}>} [Turnover Value])

mike

[Anonymous]

what do you want, allvalues for fiscal year 2015 and all data for what? for all months in 2015?

or all months including previous fiscal years?

which dimensions are in your bar Chart?

[#4]

Mike, Thankyou works perfectly!!!

[Anonymous]

Joe, would you mind to close this discussion by marking Mike's answer as correct?