Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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))