AboveBeyond
Board Regular
- Joined
- Aug 14, 2007
- Messages
- 114
Hi, I am trying to find a solution to retrieving slicer selections when deselecting values from a list.
My formula below works if I select one or more values. But it breaks if I everything is initially selected and I deselect values. The error I get is #N/A. Is there a work-around for this...is it possible to show what was deselected in these situations?
=CUBESET("Database",Slicer_Salesman,"Salesman Slicer")
=CUBERANKEDMEMBER("Database",$A$1,ROW(A1))
Thanks.
My formula below works if I select one or more values. But it breaks if I everything is initially selected and I deselect values. The error I get is #N/A. Is there a work-around for this...is it possible to show what was deselected in these situations?
=CUBESET("Database",Slicer_Salesman,"Salesman Slicer")
=CUBERANKEDMEMBER("Database",$A$1,ROW(A1))
Thanks.
