Hi,
I am trying to create a product selection type spreadsheet. The base data for the products is returned via Power Query from a Sage system.
The products have various categorisations against them and the user filters on these to narrow down the list to get to the product they want.
For some of the main products there are ancillary or related products. I want to find the bast way to display these related items to the user once they have selected the main product. I would like them to see the relevant information for the related items, description, price etc..
I remember in the back of my mind something that allowed you to add additional information to a record in PQ but I can't remember what the method was (or if I am misremembering!). Also not sure even if this is possible how much information you can add.
If anyone has any suggestions as how to tackle such an issue please let me know.
Thanks
Bax
Suggest you attach a file that shows sample data that is representative of your actual file. Then mock up your expected results so that we understand your specific needs. Your attachment should have between 8-15 records.
Hi Anders,
I think that is exactly what I was thinking of. This could possibly work for what I need.
If this isn't the solution I will upload an example file as suggested by Alan.
Thanks both for your input.
Bax
