Set Analysis Help

[#1]

Hi,

I have the following expression :

num(sum({<MonthYear={'$(=date(monthstart(max(MonthYear)), 'MMM-YY'))'}>}Number)/sum({<MonthYear={'$(=date(monthstart(max(MonthYear)), 'MMM-YY'))'}>}[Line Total]),'#,###.0%')

I would like to only calculate where the field included_in_analysis='Y' - can anyone advise how can can add this into the above expression please?

Many thanks for you time.

[#2]

Hi,

num(sum({<MonthYear={'$(=date(monthstart(max(MonthYear)), 'MMM-YY'))'},  included_in_analysis= {'Y'}>}Number)/sum({<MonthYear={'$(=date(monthstart(max(MonthYear)), 'MMM-YY'))'}, included_in_analysis= {'Y'} >}[Line Total]),'#,###.0%')

[#3]

if(included_in_analysis='Y',num(sum({<MonthYear={'$(=date(monthstart(max(MonthYear)), 'MMM-YY'))'}>}Number)/sum({<MonthYear={'$(=date(monthstart(max(MonthYear)), 'MMM-YY'))'}>}[Line Total]),'#,###.0%'))