How to return a comma-separated list of values based on sales data

Tips and tricks
1

Hello PUG team,

I’m hoping for some help, relating to returning a list of values based on what products have been sold to our customers. Specifically, I would like to have Phocas extract from our Sales Data:

  • a comma-separated list of all product categories that have been purchased for each customer
  • a comma-separated list of all brands that have been purchased for each customer

I’ve not seen a way in which I could retrieve this online, so coming back to the brains trust to see if this is something someone has done before, or could provide some guidance to a solution.

Many thanks in advance!

2

Hi,

If I’m understanding your need correctly, I wonder if you explored the Nested Table function in your database? That way you could have the Customer dimension as the high-level, then your Product Categories or Brands as your secondary level. Then when you export to Excel or CSV it formats it two different ways. Not sure if this helps!

Tim