cross table

[#1]

Hello!

I want to create a cross table where the user chooses which dimensions are uses (e.g. from a list box or something like that).
So far I can only create a pivot table (cross-tab), which uses a predetermined number of dimensions.

Is this possible?

Thanks for your help.

Steffen

[kji]

I think you can use cyclic groups as dimensions, and possibly expressions groups as well to achieve something like this.

[#3]

Yes it is possible by using If statements

[#4]

Thanks for your quick help Johan. This is exactly what I meant.

Unfortunately, should the user can select from more than 50 dimensions.
That means for a two-dimension cross-table, that in both groups each 50 dimensions exist.
The user then has 2500 different varieties. This is no longer comfortable.

Can I make it that the end user adds the dimensions of the two cyclic groups dynamically, eg by selecting or drag and drop?

Greetings Steffen