Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 ...;
you can use ciclic group
setings->document propetis->group->ciclec group->new
and use the group =SUM("name_of_your_group")