Display values in Textbox

[paulwalker]

Hi Community,

I have developed one scatter chart..

Suppose if i have Target Percentage  above 60%..

Total no.of Product-name:

Target Value:

Percentage of Selection:

These 3 values i want show in textbox.

Based on selection i have to change the values in textbox.

PFA,

Thanks in Advance....

[Kushal_Chawda]

What is expected output for current selection in text box?

[kkkumar82]

For which selections you want this to be happened, can you clear it some more

[sunny_talwar]

This?

1st Expression

=Count(DISTINCT Aggr(If(IF(vMin='--Select--' or vMax='--Select--', (Sum({<Month>}LineSalesAmount) / Sum({<Month,Year = {$(=Max(Year)-1)}>}OrderSalesAmount) -1),

  if(Sum(LineSalesAmount)>=$(vMin) and Sum(LineSalesAmount)<=$(vMax),

  (Sum({<Month>}LineSalesAmount) / Sum({<Month,Year = {$(=Max(Year)-1)}>}OrderSalesAmount) -1))) >= 0.60, ProductName), ProductName))

2nd Expression

=Money(Sum(Aggr(If(IF(vMin='--Select--' or vMax='--Select--', (Sum({<Month>}LineSalesAmount) / Sum({<Month,Year = {$(=Max(Year)-1)}>}OrderSalesAmount) -1),

  if(Sum(LineSalesAmount)>=$(vMin) and Sum(LineSalesAmount)<=$(vMax),

  (Sum({<Month>}LineSalesAmount) / Sum({<Month,Year = {$(=Max(Year)-1)}>}OrderSalesAmount) -1))) >= 0.60,

  Sum({<Month>}LineSalesAmount)), ProductName)))

3rd Expression

=Num(Avg(Aggr(If(IF(vMin='--Select--' or vMax='--Select--', (Sum({<Month>}LineSalesAmount) / Sum({<Month,Year = {$(=Max(Year)-1)}>}OrderSalesAmount) -1),

  if(Sum(LineSalesAmount)>=$(vMin) and Sum(LineSalesAmount)<=$(vMax),

  (Sum({<Month>}LineSalesAmount) / Sum({<Month,Year = {$(=Max(Year)-1)}>}OrderSalesAmount) -1))) >= 0.60,

  1-Sum(LineSalesAmount)/

  Sum(OrderSalesAmount)), ProductName)), '##.00%')