Selective displaying of column values

[Sheetal]

Hello

I have the following table. The date dimension is [startdate.autoCalendar.YearMonth]

Date             Total Attendees       Credits

2018-Sep           200                        1184

2018-Oct           200                        1184

2018-Nov           200                        1184

2018-Dec           200                        1184

I only want to display the data if the month is Sep or Oct. The month column which needs to be compared is called [startdate.autoCalendar.Month]

How can I do that? Can someone please help. Thanks.

Sheetal

[siddharth_s3]

Have you connected these 2 tables? If not, please do connect associate them.

Since it's a master calendar, I think it has other columns too. Try this perhaps. Replace SomeOtherColumnInMasterCalendar  with any other column in your master calendar table

AGGR(ONLY({<SomeOtherColumnInMasterCalendar = {*}>}Date),Date)