How to get Calculation in Rows

[khanashique]

Hi Experts,

I need to calculate the following in rows (normally we do calculations in columns)

Jobs              140

Completed      120

Open              20

Efficiency       16.7  (Calculation (20/120)*100)

The above calculation i can get in columns, Need to calculate the same in ROWS.

Thanks,

MAK

[jaumecf23]

Hi,

You can use the ValueList function.

1st. Create a Dimension like this :

=ValueList('Jobs','Completed,'Open','Efficiency')

and then an Expression like this :

if(ValueList('Jobs','Completed,'Open','Efficiency')='Jobs',

      Sum(Jobs),

  if('Jobs','Completed,'Open','Efficiency')='Completed',

     Sum(CompletedJobs)....

[khanashique]

Hi,

Thanks for your reply....

But the purpose is not solved of getting the below calculation in dimension...

Efficiency       16.7  (Calculation (20/120)*100)

Thanks.

MAK

[gerry_hdm]

an example as Excel or Qlik file would make this easier

Gerold

[khanashique]

Hi Thanks for your reply,

Below is the sample data...

Date / Period	January-17				February-17
	W1	W2	W3	W4	W5	W6	W7	W8
Jobs	15	10	11	12	22	14	19	11
Open	4	2	0	7	0	2	0	3
Completed	11	8	11	5	22	12	19	8
Efficiency (%)	73	80	100	42	100	86	100	73

Efficiency       73  (Calculation (11/15)*100)

Thanks,

MAK.