Spreadsheet: 847977d1698803535-redistribute-percentage-set-to-a-fixed-a-column-and-row-total-dhong8817-book1
Sheet: Sheet1

 | Daily 2_2 | region1 | region2 | region3 | region4 | region5 | region6 | region7 | region8 | Grand Total | Target  Percentage
 | Product 1 | 0.05078860020922642 | 0.008066638938680957 | 0.00817963263063425 | 0.006560622409293347 | 0.0135414408086338 | 0.01169214561880829 | 0 | 0.00415546412379361 | 0.1029845447390707 | 0.1057354473455248
 | Product 2 | 0.001282408931454057 | 7.439326165829307e-05 | 2.239040820737561e-06 | 0.002633683253011666 | 0.0008987345163877358 | 0 | 0 | 0 | 0.004891459003332489 | 0.004436203660252819
 | Product 3 | 1.086724708528519e-06 | 0 | 0.006220465381953168 | 0.1130602262317364 | 0 | 0 | 0 | 0 | 0.1192817783383981 | 0.1304828468311815
 | Product 4 | 0.003061669833644712 | 0.003028954764945591 | 0.01044426500945563 | 0.02091050033145193 | 0.002251002163949251 | 0 | 0 | 0 | 0.03969639210344711 | 0.04238092727527514
 | Product 5 | 0.03769306349685953 | 0.009232488471985304 | 0.006570950583589835 | 0.004265695417557573 | 0.01150629156923451 | 0.004681122379945336 | 0 | 0.00361742387418599 | 0.07756703579335808 | 0.09835933688409278
 | Product 6 | 0.004168091156282248 | 0.0008861381997799406 | 6.703145419513536e-05 | 0.0002744685115059757 | 0.001600934626724713 | 0 | 0 | 0 | 0.006996663948488012 | 0.00691865745526695
 | Product 7 | 0.04061600050134542 | 0.005983206403119962 | 0.0009815982946123727 | 0.0009458887692533331 | 0.003387162691946288 | 0.00511446431040062 | 0.0006942490484395623 | 0 | 0.05772257001911756 | 0.06118998753410695
 | Product 8 | 0.006638952568858748 | 0.001341602540157846 | 6.632632596090757e-05 | 9.398087776681953e-05 | 0.00143394847457546 | 0.001024403684014211 | 0 | 0 | 0.01059921447133399 | 0.01064362474271113
 | Product 9 | 0.008043779213212183 | 0.001172290168222811 | 0.0001354947919575628 | 0.0007308097388206805 | 0.001161635407660068 | 0.0007881223849769364 | 0.0006122649696076799 | 0 | 0.01264439667445792 | 0.01126201600063806
 | Product 10 | 0.005016163797884027 | 0.0008018161437020842 | 1.143208444506357e-05 | 3.03871471931351e-05 | 0.0006846386644410237 | 0 | 0 | 0 | 0.006544437837665333 | 0.006512787802365763
 | Product 11 | 0.008741852995225405 | 0.001758574530195977 | 9.934954889006536e-05 | 0.0003932757826839915 | 0.003047147304658995 | 0.0005017221052185945 | 0 | 0 | 0.01454192226687303 | 0.01424128459720378
 | Product 12 | 0.03423048687072502 | 0.0085360253904086 | 0.004442039360360516 | 0.02487802263425309 | 0.008623109833505126 | 0.006666813632613879 | 0.003432663876692056 | 0 | 0.09080916159855829 | 0.07984740447206076
 | Product 13 | 0.02217029606232787 | 0.005633368592815156 | 0.00373855843256692 | 0.008066393046433076 | 0.005308727511703331 | 0.005831713649094044 | 0.001268851475679715 | 0 | 0.05201790877062011 | 0.05238514192410795
 | Product 14 | 0.009764059238006535 | 0.003064600113373392 | 0.000159743434421846 | 0.0008185006364912012 | 0.00281112077782472 | 0.0006811136235318985 | 0 | 0 | 0.01729913782364959 | 0.01790147391800914
 | Product 15 | 0.0009018565993614154 | 0.0001798867268266232 | 1.429856556852145e-05 | 7.046583752387975e-05 | 0.000173285447573413 | 5.977995963057627e-05 | 0 | 0 | 0.001399573136484429 | 0.001409289387413713
 | Product 16 | 0.003613007760452965 | 0 | 0 | 0.006213883897027018 | 0.0001133055112234914 | 0 | 0 | 0 | 0.009940197168703474 | 0.00822536017846971
 | Product 17 | 0.005724114991437648 | 4.930837458053537e-06 | 7.381532382120865e-05 | 0.007608953769126349 | 0.0004866419309588504 | 0 | 0 | 0 | 0.01389845685280211 | 0.01135570680676753
 | Product 18 | 0.01498785849469374 | 0.003379656910080546 | 0.0001129082132419158 | 0.0001670695112127547 | 0.001277890488892658 | 0.0001077425394224864 | 0 | 0 | 0.0200331261575441 | 0.01606629748938991
 | Product 19 | 0.01296608514808298 | 0.002846903580895243 | 0.0008549382997478179 | 0.0003772851217247677 | 0.002760503085954277 | 0.0001139399406533538 | 0 | 0 | 0.01991965517705843 | 0.01947159498557894
 | Product 20 | 0.0002325609744637324 | 0 | 0 | 0.0001876146115572083 | 0 | 0 | 0 | 0 | 0.0004201755860209407 | 0.0002662046134316532
 | Product 21 | 0.01771025870466732 | 0.003955836851528177 | 0.02454596223531653 | 0.00886668416725326 | 0.003067335028888678 | 0.008440704600116873 | 0 | 0 | 0.06658678158777084 | 0.05096089952770841
 | Product 22 | 0.02604487305433107 | 0.006150549805831137 | 0.00116203139915151 | 0.0007258519853239949 | 0.003366597003938885 | 0.0004235692417766512 | 0 | 0 | 0.03787347249035325 | 0.0391671394358775
 | Product 23 | 0.03099361199458599 | 0.00847776106284121 | 0.01249507450268642 | 0.0104289992278138 | 0.003709327738686034 | 0.004826498752590893 | 0 | 0 | 0.07093127327920434 | 0.07121728076171556
 | Product 24 | 0.0597882471549307 | 0.01027702028552566 | 0.01934287993939593 | 0.001835143081615839 | 0.004708585590160602 | 0.006757168632697921 | 0 | 0 | 0.1027090446843266 | 0.08977283627711717
 | Product 25 | 0.02830522393774381 | 0.00710272449772149 | 0.002034559908910789 | 0.00121199787463577 | 0.002214241731733715 | 0.0008890751548130832 | 0 | 0 | 0.04175782310555865 | 0.04888528938625501
 | Product 26 | 0.0007438494305786745 | 0 | 0 | -8.958554230472296e-11 | 0 | 0 | 0 | 0 | 0.0007438493409931322 | 0.0007207042115110304
 | Product 27 | 0.0001899480448086916 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0001899480448086916 | 0.0001842564959664085
 | Grand Total | 0.4344180078898994 | 0.09195536807775406 | 0.1017555947617046 | 0.2213564037826813 | 0.07813360790925562 | 0.05860010021030564 | 0.006008029370419013 | 0.007772887997979601 | 0.9999999999999991 | 1
 | Target Percentage | 0.4344180078898995 | 0.09195536807775406 | 0.1017555947617047 | 0.2213564037826813 | 0.07813360790925562 | 0.05860010021030566 | 0.006008029370419013 | 0.007772887997979601 | 1