Indirect Set Analysis

[#1]

Hi,

Column A	Column B	Value
a	e	1234
b	a	3422
c	e	222
d	a	2
e	b	333
f	c	222

I want to build a analysis depending from my selection in Module A.

e.g. I select a in the first column and with the corresponding value in Column B (e) I want to do an additional analysis

1. Analysis (Simple ツ ) Sum(Value)

2. Analysis

Sum({1<[[Column A]]=P({<[[Column A]] = [[Column B]]>})>} Value)

Maybe I am totally on the wrong way?

Any suggestions?

[satishkurra]

Hi

Refer the below links for syntax and understanding

Indirect Set Analysis for P() and E()

Indirect Set analysis

[sunny_talwar]

What is the expected output from the 2nd analysis?

[#4]

The expected would be e = 333

[sunny_talwar]

Try this:

=Sum({1<[Column A] = p([Column B])>}Value)