how to create %value for particular cell in a row?

[srinivas1921]

Type	Item	sub item	estimate amount	actual amount
Cost	Material	aaa	120	108
Cost		Bbb	140	98
		Total cost for Item	260	206
% of comlete				% valIue(ex:75%)

Hi all
We have requirement that when user clicks on product number from main report then it will navigates to the detail level report as shown above. As shown above we need to display % value for only one expression and for rest other expression no need display anything like display blank only.

As shown Above the total of item and % of completion both are coming from database only.% value calculation like actual amount /estimate amount.

Total for item calculation everything handling from database side only but there is no calculation for % of completion from back end. Just it is displaying like lable as % of completioncompletion in the front endend.Now I need to display % of cometion value for particular cell in a expression as shoam above in the pivot table

Please provide a solution on this...
Many thanks in advance.....

[vishsaggi]

I am not sure about other missing information how it comes but just try this ?

Load data as :

LOAD Type,

     Item,

     [sub item],

     [estimate amount],

     [actual amount]

FROM

< Your data source >

WHERE [sub item] <> 'Total cost for Item';

Use a straight table:

Dim: Type, Item, [sub item],

Expr1: = [estimate amount]

Expr2:= IF(Type = '% of comlete', Num(Sum(Total [actual amount])/Sum(Total [estimate amount]), '#,#00.00%'), [actual amount])

If you want that Sub item row as well, just remove the where condition and just load the data.

Like below?

OR