Set Analysis

[psankepalli]

Hello Experts,

I have the following code,

Fact:

LOAD *

Inline

[

Key, Value

1,10

1,20

2,5

];

DIMENSION:

LOAD *

Inline

[

Key, Brand

1,ABC

2,ABC1

];

Exit Script;

My requirement is whenever I select ABC from Dimension, I need a value of both ABC + ABC1 value and

BRAND	SUM(VALUE)
ABC	35
ABC1	0

How to achieve this unique requirement? I don't mind to use any type of set Analysis.

I want to acheive this unique requirement.

Please help.

Thanks

PR

[Kushal_Chawda]

Try this

Create Straight table

Dimension:

Brand

Expression:

alt(Pick (match(Brand,'ABC','XYZ'),

sum({<Brand={"ABC*"}>}Sales),

sum({<Brand={"XYZ*"}>}Sales)),0)

or

alt(Pick (match(Brand,'ABC','XYZ'),

sum({<Brand={"ABC*"}>} total <Brand >Sales),

sum({<Brand={"XYZ*"}>} total <Brand >Sales)),0)

[psankepalli]

Thank you all for your help.

[psankepalli]

Hi Settu,

Thank you very much, this is what I am looking for. if any change in requirement I will get back to you.

Once again thank you very much for your help.

Thanks

PR