Dynamic Grouping in straight table depending upon selection

[#1]

hi,

I have 3 dimensions - A,B,C and based on selection of dimension through dropdown. I want to group data according to that dimension .

I can do this using if else but want to keep it more dynamic as dimensions cab be increased  later.

suppose data is like this

A     value    B    C

a1     10        b1   c1

a2      20       b2    c2

a3      30       b3    c3

on selection of A

A           Sum(<A> value)

on selection of B

B           Sum(<B> value)

on selection of C

C           Sum(<C> value)

regards

Anubhav

[#2]

you can resolve this on script, i think you perfomnace will be better this

Table:

load A as info,

     'A' as Type,

value

from ...;

concatenate(Table)

load B as info,

     'B' as Type,

value

from ...;

concatenate(Table)

load C as info,

     'C' as Type,

value

from ...;

[#3]

you can use ciclic group

setings->document propetis->group->ciclec group->new

and use the group =SUM("name_of_your_group")