how to develop a comparison table with actual and target values?

[#1]

Hi Qlikers,

I need help on develop a table as below.

But this table cannot be build using Pivot or Straight Table or even Table Box.

Does anyone know how to develop this as i know the first column should be the words that we can key into field, is not a dimension that we can pull from database.

Below are the only result that i can get. But i need the left column name and i have more than 10 criteria to compare.

[#2]

It seems nobody know how to solve? or do we have relevant post regarding this topic?

[#3]

Hello,

for the dimension you can use a valuelist:

valuelist('Actual Sales Vs Target Sales','TotalRevenue','Gross Margin')

and in the part of expression the first expresion for Target Sales should be something like this:

pick(match(valuelist('Actual Sales Vs Target Sales','TotalRevenue','Gross Margin'),'Actual Sales Vs Target Sales','TotalRevenue','Gross Margin'), <Formula of Actual Sales Vs Target Sales >, <Formula of TotalRevenue>, <Formula of Groos Margin>)

hope this helps!!

Regards