Expand values as columns

Aho!!!

I would like to create a summary table where column values should represent country of origin, rows - items and values - price. I really do not want to create this large amount of columns for each country. Is it possible to expand one column values to separate columns?

Can you please illustrate your message?

Sure

Attached Files

Download summarytable.jpg (27.3 KB)

Where do you want to create this?

If this is a report, you should use Data composition scheme, cre ate table in settings section and select rows and column. It is automatically expandable.

Yes, I'm using the Data composition schema. Could you show an example please?

Try to use a wizard in the settings section. The icon looks like a wand with stars.

Simon, here is example

Attached Files

Download 26.03.png (144.52 KB)

Download 1Cv8.dt (14.17 KB)