Comparison

[Anonymous]

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 ?

[Icey · Accepted solution]

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.

[amitchandak]

@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

[az38]

Hi @Anonymous 

add both of fields, Actual and Plan to Values in Visual Pane