i have 2 fields:
Region Name field2 field3
-------------------------------
Central 0.47588
East 0.05197
North 0.40546
South 0.42523
West 0.37039
Now I want field3 to show the values as field2(1)/TOTAL(field2)
Ex: above total is 1.72893, so central fielsd3 value should be = 0.47588/ 1.72893 ? 27.5245383
Output should display as
Region Name field2 field3
-------------------------------
Central 0.47588 27.5245383
East 0.05197 3.00590539
North 0.40546 23.4514989
South 0.42523 24.5949807
West 0.37039 21.4230767
How to do this on report studio
Region Name field2 field3
-------------------------------
Central 0.47588
East 0.05197
North 0.40546
South 0.42523
West 0.37039
Now I want field3 to show the values as field2(1)/TOTAL(field2)
Ex: above total is 1.72893, so central fielsd3 value should be = 0.47588/ 1.72893 ? 27.5245383
Output should display as
Region Name field2 field3
-------------------------------
Central 0.47588 27.5245383
East 0.05197 3.00590539
North 0.40546 23.4514989
South 0.42523 24.5949807
West 0.37039 21.4230767
How to do this on report studio