If Type='Statistical' then sum(Sales Qty)/sum(Actual Qty)

 

I am using only one Query but I am not able to bring those two calculation in the same single chart for two different series (Final and Forecast)

 

Month Name,type, Sales Qty, Actual Qty are Universe Objects from Single query.

 

It's displaying only Final not statistical.

 

And also I did work around for two query one query for Type='Final' and another query for Type='Statistical'. This is not feasible I guess, because There is no sinchronization on common dimension between two queries.  Equi Join will not work for some cases if either query having more records than other.

 

Please provide any one having same experience or idea or suggession.

 

Thanks for all for sharing skills.

-Chittu