6 Replies Latest reply: May 29, 2011 8:33 AM by Sushma Koyi RSS

    two dimension Vs Two Expressions

      Hi,

       

                I have two dimension's like actual year and estimated year as dimensions.Both counta,countb as their counts as expressions.But i was struggling to link accordingly since from three days.

               By the way,I have used

      =ValueList(actual_Year,Estimated_Year) as dimension and 

      =if(valueList('actual_year','estimated_year')='actual_year',counta,countb) as one expression
      =if(valueList('actual_year','estimated_year')='estimated_year',countb,counta) as another expression also.but it is not giving desired results.

       

      Does any one know the solution for this?Please provide me the clue to do this?

       

      Thanks& Regards,

      Sushma K