Columns in Pivot chart

[marwen_garwachi]

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

[marwen_garwachi · Accepted solution]

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