Filter out dimension based on selection

[hkapadia]

Hello,

I have a straight table where fields Year1 & Month1 are my dimensions. I have a filter with fields Year2 & Month2. What I am trying to show in the table is only values from Month1 field where Year2 filter selection = Year1. In my data model, I load completed month data for current year and the past year. If the filter Year2 is 2018 then my straight table dimension should only show Jan as the only completed month so far, if the filter Year2 is 2017 then my straight table dimension would display all 12 months. Is it possible to do this?

[sunny_talwar]

Year1 and Year2 are different fields? or it's just you calling them different names because they are from different objects?

[hkapadia]

They are different fields

[sunny_talwar]

May be this

{<Year1, Year2 = p(Year1)>}

[hkapadia]

I am using Calculated Dimension & I used

=only({<Year1, Year2=P(Year1)} Month2)

as the expression as I only want to show months for the year selected in Year1. This is giving me 'Error in calculated dimension'.

[sunny_talwar · Accepted solution]

May be this

Aggr(Only({<Year1, Year2 = P(Year1)}>} Month2), Month2)

[hkapadia]

Thanks Sunny. That worked.