Bubble size

[paulwalker]

Hi Community,

I have Scatter chart.. I have 2 expressions..

Exp1:

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)))

Exp2:

Num(1-Sum(LineSalesAmount)/  Sum(OrderSalesAmount))

What should i write expression for Bubble size ??

PFA

Thanks

[paulwalker]

I have written for bubble size..

Sum(LineSalesAmount)/  Sum(OrderSalesAmount)

But its not working properly..

I have data 2005 to 2010.. Here comparing data year on year..

when i am click 2005, it should be no data to display.

[sunny_talwar]

This

Num(1-Sum(LineSalesAmount)/  Sum(OrderSalesAmount))

or this

Sum(LineSalesAmount)/  Sum(OrderSalesAmount)

both doesn't seem to be year or year. They are going to be values for the selected year. What are you looking to do? May be restrict the above two expression like this:

If(Len(Trim([Target])) > 0,

Num(1-Sum(LineSalesAmount)/

  Sum(OrderSalesAmount)))

and

If(Len(Trim([Target])) > 0, Sum(LineSalesAmount)/  Sum(OrderSalesAmount))