How to do a normalization with respect to a particular value in X axis?

[Pavinkumar R]

I've a line chart with X & Y axis with color by few conditions. I want to know if there's a way to normalize each individual plots with respect to particular X value?

For example, In the below chart, I want to normalize the plots A & B with respect to their value at a particular X value. Let's say, I want to normalize the plots at X=3. In this case, I want Plot A to be normalized with the value 6 & Plot B to be normalized with the value 4.

Thanks in advance.

 

[Pavinkumar R]

I just got to know about the OVER function. This helps to achieve what I was looking for.

Example :

Sum([Y]) / Sum(If([X]=3,[Y],0)) over (All([X]))

This will result in below graph :