Group dimension by selection

[Anonymous]

Hello there!

I was wondering if there is a way to group dimensions in a chart by the selection of the user. I will put an example to make it easier:

Imagine that i have dimensions A,B,C. Imagine now the following table:

             expressions

A               values

B               values

C               values

Can i do something so when the user selects (for example) A and B the table appers like this:

             expressions

AB          avg(values)

C            values

If the user selects A-C, C-B or whichever possible combination expect the respective results.

Thanks fot the help!

Lluís

[its_anandrjs]

What is expected O/P.

[its_anandrjs]

Or you can use the Pick() , ValueList() function combination for this.

[jpenuliar]

you probably could use GetfieldSelections() to achieve this