Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
drohm002
Contributor II
Contributor II

display specific values from a dimension field

Hi, I have a field called "Month-Year", that has values like Jan-17, Jan-18, Jan-19, Feb-17, Feb-18, Feb-19 and so on.  How can I get the dimension to display only the values from 2018?  Thank you for the help!

1 Solution

Accepted Solutions
m_woolf
Master II
Master II

=if(year("Month-Year")=2018,"Month-Year")

View solution in original post

2 Replies
m_woolf
Master II
Master II

=if(year("Month-Year")=2018,"Month-Year")

Taoufiq_Zarra

Maye be

if(Year(Date#(Field,'MMM-YY'))='2018',Field)
Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉