Forum Discussion
how to filter multiple vendors number?
goodmorning gents, talking about the P&SC OTD dashboard, how can I filter a multiple vendors number selection, for example more then 30 vendors in the dashboard? the onl way I found is to filter manually by vendors number that it takes lot of time and trial so no really feasable.
thank you for your suggestions
regards
Alessandro
1 Reply
Hi abottino ,
It sounds like you could add 'vendor groups' to your vendor dimension table to speed up bulk selection.
In your vendors dimension, you would have, say, [vendorID], [vendorName], [vendorAddress] etc.
You could add a new custom column that groups the vendors by region, or product type, or payment terms etc.
You then use the new [vendorGroup] column in a slicer to narrow down the potential vendors very quickly.
Pete
