This content has been marked as final.
Show 6 replies
-
Re: Get dimension values not selected
Kaushik Solanki Jul 14, 2017 6:48 AM (in response to Victor Torres Jurado)Hi,
Create a table Object and put all dimensions and put expression as below.
Sum({1-$}1)
Regards,
Kaushik Solanki
-
Re: Get dimension values not selected
Victor Torres Jurado Jul 14, 2017 7:00 AM (in response to Kaushik Solanki )Thanks for your answer kaushik.solanki
Your solution almost fits, but I get the Employee 1, that is in 2 sections (A and C -selected-)
Is possible that Employee 1 doesn't appears?
Thanks in advance
-
Re: Get dimension values not selected
Kaushik Solanki Jul 14, 2017 7:16 AM (in response to Victor Torres Jurado)Try this.
Sum({<Emp = e(Emp),Section=>}1)
Regards,
Kaushik Solanki
-
Re: Get dimension values not selected
Victor Torres Jurado Jul 14, 2017 7:20 AM (in response to Kaushik Solanki )perfect!
Thank you very much kaushik.solanki!
-
-
-
-
Re: Get dimension values not selected
Vineeth Pujari Jul 14, 2017 7:26 AM (in response to Victor Torres Jurado)or if you need just a listbox of excluded values then try below
AGGR(ONLY( {1-$} Employee),Employee)
-
Re: Get dimension values not selected
Victor Torres Jurado Jul 14, 2017 7:45 AM (in response to Vineeth Pujari)Wow!
This is even better! Thank you vinieme12!
-