Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can i filter value in a straight table/pivot table? I understand that in List Box, there is a "lookup" icon. Is there any way i can "lookup" in a straight table?
thanks in advance
Hi,
Let try Chart Properties -> Presentation -> Select Column -> Check Dropdown Select

Regards,
Sokkorn
There's no lookup function. But you can simply click on dimension values to select them. Or drag the mouse over a set of values to select those. Ctrl+click'ing to select multiple individual values doesn't work though.