How to give Pivot table result to a Formula

[robinmech]

Hi I'm trying to use Pivot table result in a formula. But result is getting only with the first cell.

For Eg:
1100
1000
2550
4000

are my pivot table result. Let say sum of quantities. When I'm trying to divide this with 100, getting 11 as result in all the corresponding columns.

Please help

 

[Sanjeev1976]

Use the cell reference like "=A5/100" rather than the reference from the pivot table

 

[robinmech]

Use the cell reference like "=A5/100" rather than the reference from the pivot table

thank you and sorry for the late reply.