Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
What is the expected output from the 2nd analysis?
The expected would be e = 333
Try this:
=Sum({1<[Column A] = p([Column B])>}Value)