Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
See if aggr() helps:
aggr(ONLY({<YEAR={'2017'}>}company),company)
It is working. Can you please logic too. thank you so much
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.