values gets added as apply in filter

[Tisha Sharma]

Hi,

 

I have a requirement that i have two columns , i want sum the values oftwo column but the condition is from 2nd column value not all values gets added only which i pass in filter for that 2nd column that value gets added in 1st column .

For eg: valuecolumn 1 = 20 and in filter on 2nd column is 2 then i want 20 + 2 = 22

as filter change the value of 2nd column gets changed and vaule of sum is also gets changed .

Kindly help in resolving this .

[Ghantasala Krishna Kowsik]

Apply same logic on custom expression (Value Axis). Value gets updated as on filter changes. Try it not sure