Hi All,
I have a scenario where that I'm not sure is possible but thought to reach out to the experts to check. I have a dashboard where a client would like to report out using nPrinting, which is fine. However, we have a data set that shows stockist across several dimensions as so:
| Product | Sales | Cost | Stockist1 | Stockist2 | Stockist3 |
| Product A | 50 | $5 | Shop1 | Shop2 | |
| Product B | 25 | $15 | Shop2 | | Shop3 |
| Product C | 60 | $25 | Shop2 | Shop3 | |
Essentially, they want the Stockist field(s) to be the key dimension, so the requirement would be to group all of the information from the three fields and then show the information as follows - note that the sales and cost can repeat:
| Stockist | Product | Sales | Cost |
| Shop1 | Product A | 50 | $5 |
| Shop2 | Product A | 50 | $5 |
| Shop2 | Product B | 25 | $15 |
| Shop2 | Product C | 60 | $25 |
| Shop3 | Product B | 25 | $15 |
| Shop3 | Product C | 60 | $25 |
If we can create the table as above, then I can use the 'new' Stockist field to cycle through in nPrinting. Just to make life a lot more awkward, this is an existing dashboard, so i will need to be careful on making too many changes to the data model or script.
Any advice or tips you can provide are gratefully received.
