Set analysis on dimension

[#1]

Hi,

I am trying to do set analysis on one of dimension. I am trying to get in pivot table, company names for only year=2017

For Example:

ONLY({<YEAR={'2017'}>}company)

This is simple code, but I don't know why its not running. It's showing me invalid dimension. Please let me now what I am doing wrong or suggest any alternatives.

Thanks

[Anonymous · Accepted solution]

See if aggr() helps:

aggr(ONLY({<YEAR={'2017'}>}company),company)

[#3]

It is working. Can you please logic  too. thank you so much

[mikaelsc]

without aggr, you get multiple values of companies in 2017, so not only 1 value.

with aggr, you get 1 company in 2017 per company.