Pivot Table question

[salto]

Hello,

I have a pivot table in which I would like to add the '%' line:

Item	Value	Header 3
Item A	sum(Amount) = 375
Item B	sum(Amount) = 125
Item C	sum(Amount) = 100
%	(Item C) / (Item A)
Item D	sum(Amount) = 250

Is it possible, in the pivot table, to get the value of items A and C to perform the calculation?

Thanks in advance for your help.

[Anil_Babu_Samineni]

How many Items you have?? Will you able to provide some data set to check?

[arvind_patil]

Agree with you require sample data.

Thanks,

Arvind Patil

[rahulpawarb]

May be this:

Data:
LOAD * INLINE [
Item, Value
Item A, 375
Item B, 125
Item C, 100
Item D, 250
];
Concatenate
LOAD '%' AS Item,
     Num(Sum(If(Item='Item C', Value, 0)) / Sum(If(Item='Item A', Value, 0)), '#,##0.##%') AS Value
Resident Data;

Regards!

Rahul Pawar

[qv_testing]

PFA,