% of Row Total Expression

[muniyandi]

Hi ,

In pivot table more then one dimension and single expression how to compare the current row value to Row Total value.

Kindly verify my excel attachment file.

Thanks.

[jerem1234]

Use this formula instead:

sum(Amount)/sum(TOTAL <$(=GetCurrentField("New Group"))>Amount)

Hope this helps!

[muniyandi]

hi,

Dim1	Dim2
	A	B	C	D	E	F	Row Total
Jan-10	1000	2000	1500	1400	1600	1000	8500
Result	11.76%	23.53%	17.65%	16.47%	18.82%	11.76%	100.00%

friends,

i need calculate to Current row Total value with current cell value comparison .

1) First Get row total value 8500 ; ( how to get 8500)

2) current row Jan-10 and  cell is A Now (1000/8500)*100 = 11.76

Just refer my attachment excel pivot table.

Normally we are only get on column total only. how to get row total and dynamically change the dimension means how to handle.

//Sum(amount) / Sum(Total amount) is Column Total . (That is get the total amount of amount Column)

Thanks,

Muni.