Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a Pivot chart wich contains 4 lines (A,B,C,D) calculated in dimension (If Field = 1 ,A, If Field = 2, B etc....) i need to calculate an expression :
If dimension value = A then score = Field_A *2
If dimension value = B then score = Field_A *4
if dimension value = C then score = Field_A *6
if dimension value = D then score = Field_A *10
How can i do it ?
Dimension | Score |
---|---|
A | |
B | |
C | |
D |
Thanks for your help
I found it ! i've tried this expression and it works
If rowno() = 1, Field_A *2,
If rowno() = 2, Field_A *4,
If rowno() = 3, Field_A *6
If rowno() = 4 Field_A *10
Thanks to me
I found it ! i've tried this expression and it works
If rowno() = 1, Field_A *2,
If rowno() = 2, Field_A *4,
If rowno() = 3, Field_A *6
If rowno() = 4 Field_A *10
Thanks to me