How to connect a long list of vendors with multiple other lists
Does anyone have experience creating a module with a long list of vendors (4000+) by multiple dimensions (market, department, legal entity, business unit) without breaking their module? Currently we are only able to show by one dimension but we really need it by all four, would greatly appreciate any insights on how to accomplish this.
Answers
-
Do you mean pivot the dimensions?
Currently you can put up to three dimensions at each axis. But there is a small life hack how to bring more than 3.
You have to drag the selected list to the small section (even to the very corner) which is marked red
5 -
@AlexGSG The alternative is to create a new list with the combination of all lists Vendor+Market+Department+Legal Entity+Business Unit and have all the dimensions defined as line-items and in rows to publish the combi list.
@KirillKuznetsov : Thanks for sharing! 🙂 WOOW.
0 -
@alexpavelOne small disclaimer that additional dimensions can cause possible performance issues, so keep that in mind
1 -
Not exactly what I was looking for but good to know! We were able to make the data fit by splitting it into 6 subgroups. I really appreciate how quickly I got responses, thanks and have a fantastic week!
0 -
Indeed...as everything in life, it has a price to pay 🙂1
