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 Actual and Plan and I would like to display them side by side. Is a Matrix table the right solution ? How can I get the Plan section to display next to the Actuals ?
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.
3 Replies
Hi Anonymous
add both of fields, Actual and Plan to Values in Visual Pane
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
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.
