Logic Help

[abhaysingh]

Hi all,

i have one requirement can any one help me in this?

Header 1	Header 2	Header 3
A	1
B	2
C	3
D	4
E	5
F	6

Output should come in table like

Header 1	Header 2
ABC	6
DEF	15

A+B+C = 6

D+E+F=15

how i can do this?

thanks in advance

[alexandros17]

What is the logic?

You have to sum the first and the second 3 element or you have to sum Always A,B C then D E F?

In this case use a straight table

add a computed dimension:

If([Header1]='A' or [Header1]='B' or [Header1]='C', 'ABC', 'DEF')

Add a new expression:

Sum([Header 2])

[awhitfield]

Hi Abhay,

created a calculated dimension as follows:

=if(match(Header1,'A','B','C'),'ABC',
if(match(Header1,'D','E','F'),'DEF'))

See example attached

HTH Andy

[PabloOrtiz]

hi,

create a computed dimension like this

=IF([Header 1]<'D','ABC','DEF')

and an expression like this

sum([Header2])

[abhaysingh]

hi Alessandro,,,

thanks for revert but this is something Static Solution... Not Dynamic.. what if my Data will Append??

suppose xyz value would come..than it will not work

[abhaysingh]

Hi thanks for Revert but i am looking for dynamic solution

[PabloOrtiz]

Example

[CELAMBARASAN]

Create a Grouping based on the Criteria you want to combine.

Can you explain on what basis you are combining A, B and C?

[abhaysingh]

Hi Celambarasan...

Suppose i have 100 value in header1 field than i want to group them according to first 3 letter would be ABC, than next three would be Def and so on

[alexandros17]

Simply add this dimension and expression:

If(Left([Header1],1)='A' or Left([Header1],1)='B' or Left([Header1],1)='C', 'ABC', 'DEF')

Add a new expression:

Sum([Header 2])

let me know