Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
One of my user asked me for make a multi selection on dimension in a pivot chart. Non problem for select one value but unable to select more.
Regards
AFAIK you can't do this on a pivot chart, you may need to add a list box too.
Andy
On second look, enable Dropdown Selection on the presentation tab for you first dim, then you can multi select form the drop down:
Andy
Within the tab presentation you could enable a dropdown by each dimension - and then your user could click on this dropdown-arrow and choose their wanted values and even use operators or expressions, for example by a date-field:
>=01.01.2017
- Marcus
Hi,
What if you would set this column as "Dropdown Select"? Go to chart properties, Presentation tab, select your dimension and check "Dropdown Select" checkbox.
Then your user should be able to use this dimension with a functionality of listbox etc.
Not sure if that's what you were asking for, but hope this helps.
Good luck!
Thanks to all for your answers. In fact i had already thought to Dropdown Select. But it's not so easy because dimension value are linked to a slider.
So when i use Dropdown, it display all value of my dim, not only those associated with the slider selection.
Maybe you could use a calculated dimension, like: aggr(only(YourField), YourField) which would react on the current selections.
- Marcus