Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I have a dimension Doctor.
I am using it as a filter.
Conditions:-
1.) If i don,t select any year then need to show doctors for current year .
2.) otherwise according to the years selections.
Like
Doctor Year Revenue
Sunny 2014,2015 ,2016 455667
Manish 2014, 2015 467787
Arjun 2014, 2015 ,2016 454767
Jagan 2015 754344
Mohit 2014 4577
By default 2 doctors will be present in the List box only Sunny And Arjun.
If i selected 2015 then Manish and Sunny and Arjun, Jagan will be in List box.
And if i selected 2014 then All except jagan.
Regards,
Mohit Dahiya
You are unable to select 2 doctors?
Yes bro i am unable to select 2 doctors
And this data is available only when i am selecting year i. I need according to months and days also in same condition.
Well I guess follow the same logic (as we did for years). For selecting two values, try this slight modifaction
Aggr(Only({1<Year = {"$(=If(GetSelectedCount(Year) = 0, Max({1}Year), Max(Year)))"}>}Doctor), Doctor)
But Bro when i select any date it is showing nothing see.
All things working fine but when i selecting for a proper date it is not working
I am not sure how date is related to that chart brother? I have only been helping you with a list box object for doctors. I have no idea where did date and those object came in from