Assistance required to achieve the result in expression

[ashmitp869]

Hi ,

How to achieve Phase per episode ?

The data sample is below - where we can see one episode has 10 phase

So I used the expression : Sum(Measure_Phase)/Sum(Measure_Episode) to achieve that. Its working when only one Episode is selected.

By no selection is there: I am getting an output like below chart : 

Is it taking the avg when no episode selection is done ?

below is the result when selecting only one episode:

[sunny_talwar]

What do you want it to do when no selection is made? Sum the value for each Episode?