Forum Discussion
Comparison
Hi All, I am trying to show a comparison between Actuals vs Plan. I am using a Matrix table and for some reason only the Actuals shows up. In my source data (Excel) I have both a column for Actua...
Hi Anonymous ,
What is the structure of your source data?
If Actual and Plan columns are in one table, create a table visual or matrix visual like az38 said.
If they are in two tables, create correct relationship between the two tables. Then create a table visual or matrix visual like az38 said.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
You may have to create a table like this
union(
summarize (Table,"Name","Marginal ROA","Actual",[Marginal ROA Actual],"Target",[Marginal ROA Actual]),
summarize (Table,"Name","Effciency Ratio","Actual",[Effciency Ratio Actual],"Target",[Effciency Ratio Actual])
)
Or Convert measure to dimension values