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?
I haven't typed any thing on that chart ,what ever the variables and function are there i used and pasted always for the dynamic variables.so,No mistakes as per the syntax.I verified and corrected that syntax errors immediately if any.
I have attached the actual requirement(but it is clubing the both results into one and taking it as it is for other bar also).In that picture,Selected year is a combination of actual_year & estimated_year.(union of both).