SSRS SUM(IIF()) on a matrix.

  • david_h_edmonds

    Ten Centuries

    Points: 1232

    Hi, apologies if I am asking a question that has been asked many times but I can't find the answer that I need.

    I have a matrix in ssrs and I am wanting to add a column into it that shows a value as a perentage of the row total as you can do in excel as follows:

    I have tried sum(iff()
    I have tried sum/sum
    I have tried helper fields and I still can't get it going.
    Does anyone have a way to explain this for me please?
    Expr for the field is:
    =sum(Fields!Booking_Count.Value,"matrix1_Booking_Channel")/sum(Fields!Booking_Count.Value)
    My matrix is as follows:

    data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAABGUAAABCCAYAAAD+DGvDAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAB5jSURBVHhe7Z2xsuQ2kkVfb7TR8wfrtqEIyR1zTZljzJfInM8YU18yhswx1xxXipDRv7Ce2ugILRPE5cu6hQRAFsgi37sngsq6yEQiAaKqWiy+qg9/TrwIIYQQQgghhBBCiEP5r2yFEEIIIYQQQgghxIHooowQQgghhBBCCCHEE9BFGSGEEEIIIYQQQognoIsyQgghhBBCCCGEEE9AF2WEEEIIIYQQQgghnoAuygghhBBCCCGEEEI8gZufxP71t19fXr5NDz5Ox2Q/ffz08vXbV+mDNNvR+aWlpaWlpaWlpaWlpaWlpffXZn/4/ofpQZ27izI9ncQ+2Pr/+4ut/3QiXz7JysrKysrKysrKysrKyspe0P74ue/6ys2fL31KCcSzSOtvV9Ymm66wGdLS0tLS0tLS0tLS0tLS0pfSvddXdKfMidCdMrKysrKysrKysrKysrKy17eb7pQRz2fEFTlpaWlpaWlpaWlpaWlpaeln6j50p8yJ0J0ysrKysrKysrKysrKysrLXt/pOmQvC3ynz09/+Mh0fkn3sCl2sLf/IfKP0XNerHp1/rfb1+POyNZ+0tLS0tLS0tLS0tLT029X6TpkLwnfK2P/4//yLnZ5X7fn5lz+m/95fkVtj7cJClIfH38OmCxsOjFer6xm2VM8R6yMrKysrKysrKysrKyt7PavvlLkot1fY7vU///VHujjw82TtQkHPFbqaXij47YLDo/lr2ur387Hxbi88jR3vIZ1gP5+fB/JLS0tLS0tLS0tLS0tLvyHdh+6UORE9d8q0tMff2dF7R4rXyO8tqI1reH/J8riR39e9Zj6lfmvnweN57fNBy8rKysrKysrKysrKysqa1XfKXBD+TplEp54vELzecWJ3oKQLE5PfbM8dKenCw+S/zz9/90ypPy5M+PxGq96Fih/18HzMX5sPz9c08nO9c7/6+vXUKy0tLS0tLS0tLS0tLS0N3Xt95eaizNd0RUc8i7T+H+3ETScw2QnSP/19/pLZf0w2kf0Lxf7TtrjRfJ6/pnx2USLqbxcqEkH/1njh+BV/XE8l34T1u/W/1jPPw/VP9NWTCPzS0tLS0tLS0tLS0tLS0tC911f0nTIn4/YK272u3SFyf4WO+zt/Yt44uCNla/8E+1s6sdb/Wo/N2+qGnWnVcz8fj8+Hde2tpzyetLS0tLS0tLS0tLS09PvUfeiizMm4vcLW0nyi+QrdffyiE3N/u8hjd+Bs7Z9gf0sn1vrnetJFpF/+nC9OZTvTqqe+fj4fbE89iZxPWlpaWlpaWlpaWlpaWroXfafMidj0nTIJd96K8dP2uNF8nufvaEl3nGzsD//dHSY5nnU03tx/3XxSnhva9S86UR7P17fA/aWlpaWlpaWlpaWlpZOdkJbOuvf6in596UT0/PoSU/PPd5DYRri/cIF+1s5x0Bif6yjFgSg+sr11mfV5fT+LQ3yt35p5GD5Pqx7fLisrKysrKysrKysrK/u+be+vL+mizImw9f/l988vnz5O4ttL+pMiu6ME2m6BSlfcTq7Tlwbbd9QMyndWfdXzIy0tLS0tLS0tLS0tLb2v/vG7L7ooczX4ThlZWVlZWVlZWVlZWVlZWdnr2d47ZfSdMidi03fKSEtLS0tLS0tLS0tLS0tLn0rrO2UuiO6UkZWVlZWVlZWVlZWVlZW9vtV3ylwQW//5b9GmY7L2c1rpipv0IZrt6PzS0mfWbEfnl34fmu3o/NLP1WxH55d+m5rt6PzS70uzHZ1fWnqkNquLMhfD1v/rp2n98wmUPdZ++qr1l32/VvtfdoTVPnrbVudXdovVvpEdabWfZK9kbb/2XF/Rd8qciPk7ZebHX7OVno6JI7TWf0I68R619v+EdEJ6ttKzkZ6t9Gy2aL2/TEgnRmjtpwnpxBV02q8d3FyU+Zr+9kk8i7T+dmVtIv2MliGdOEJr/SekE+9Ra/9PSCekZys9G+nZSs9mi9b7y4R0YoTWfpqQTlxBp/3awc1FGfF8RlyRS0gnpGcrPRvp2UrPRnq2I7U+wZx4w1rnd0I6IT1b6dlIz1Z6NtKzhe5BF2VOxogrcgnphPRspWcjPVvp2UjPdqTWJ5gTb1jr/E5IJ6RnKz0b6dlKz0Z6ttA96DtlTsQzP4H66+cP84PO+Leo9QngxI76r999SPvM7Ih8iQH62fWcZT20/yc6de318mz725CerfRspGcrPZsjtN5fJibr/x00Ip9xBn30fLSfJiarf29cQ6f92oF+felE9P760vI/BJn//D6dwkp8j7UndpTHxvvPl8lX6PeI3WMeNduax5pvc09vQMTe9a+xtfP5DNvaX56j616zv/m8j3he1MY/8jxu+TWD3vXomQfvA4/ljfyWN8r/SPvW87JmP/VYzDuq1xg5HuzWeez5qxiYL0B93G7wepX2T21+a+N7bG3frLWj91mvPfOvnkT7oxTXOg/R8w7r3rs/OC4a18c947xiXpF+1D5r3/Suf699ZF1q+47r9Nh4kd/yRXlr7Z4R57m2Lj3Pt7W2Zz9hnlxXbz21uNb5KuXbw0brXtsvpTw9do/zaBbnCfSu35Z6avt0T2v7dfWvL4nn03sFzjaiHf87HWlDN+KbOlPyp03P8Q/q9MTI9WMuNo9R+XfXE6euPzMs36M6E/mxhsP2807aQK3pnOONr7P/Wm3rkeiMP1obXeuRqeWz/ng+GTc6x/nnG/yGPebnn+lw/TJcz8KkLWdYbyb0j9YZ9i9w/ABdnX9F7/UJJs4nzn065+4fnqa93++H0vtNign269r4Xr3QGX9GfeZPqI2u85XpyZcI/K39gX2Ew+Kj9zfzG8kW/MaR2uoYmc84Wq9Zf2NvvVDwoz6zxo3OcbzfTBv22L/eWTxeL6GNxT+B/qlv3ret+rdqG8MYla9XL7A/s7n/ZP36GTe6EG8crVEPjnA/dOpH+5e07VNfn9ne/bhHPYmddA+6U+ZErLlTxl/pK2mPbXL0T29IDvTDE8PHQSO/t6A2ruH9Pq7U7m1vnT5frb4on8+z5pOcWh3we3y79YO/J94T5TH8+fJwnIE8pXijNb6fd5SnVg/343qiebbq4njDj1fqh/F8ncjn6/T5a9rj80Tr0Dt/WFAb1/D5QTQvs1s+yURdkTaL+fA8a7aWp6dfqX8prtbO54HxcUzUz7ejThDVG61fqb13vCje4Pl7C9C/VO8en4ij/rV+P+9a/6hfLc6vh+Hjrb+H189AXR5/Xry/tN44L9yO/h4fF53HZ57fURbrFmmzWLfa+tXiWv1b/pr19fo8wOfz7Ybv5+nJV9ovPp7HrfVDHNuj9w3XXbK1+nvXifP6fkbrvHB/jMP+3vlYv1L/UlxNe6J1MdCP6/Oa6/L5a+Ma3u9tz37icbnddG0+nqgOzod2zB95esarrZ8nijPdajdbqxd+4ON6183yeP+aOthG4/j+3oIor58n+31/w8dF8+mZp1nbr6vvlOn9myexDyM+gUobbtqM/gqpbTTzY+N6P294y2dx0RVIzo/+aMfxyBVMjO/zcZ1R/6g+1IN8pf5r1n+h4G/V7/1RvOWzdmiej8F+05bPtAGfEdXD62WH0Rqf1wN5fHytHu4f6gnLg/Hhj+Zj+Pjkm3Q0n6j+JV+hHqOkS/mRp7Y+BvIhjvMbnB/9zfr52gGQj+tZ8rvxN73+ZELN8Z16oTN+0UwQvxD09/Fr1hc+68/nyyzW34jOp8H19ure8aL6AOfHPHEseWn8vfTCWj8T9F87Hq+HP39msZ44rL9Zw8fD33O+EtnWdGl85EXdPB7PZ6mjYzzjNDoTao4/m85A954v8/t2f/5tP7TyoT/69NRb27+l+LPdYVWrH+uEA+322EA850c/+FPfvP7oC3+C+kMvBP5QM0H8QkGvef1IPre/kA9xd/knOD/6m0Ub/KA03679xFD73ufL509M7dBm7Sitn9e8XqlPPh+leKOlFwp+Hu+mvgzmhcPiLQ752B/Wm6nVi/xLrkI9hrUjhuup5TdMc/80Vq47mg/aOb6UP+3XDm4uyvT+jrbYhzW/avA/0wayTZQ23sTiz7T6czzAxozi05XAiah/c7yNmonio/pa+U2vWX8D62+HnQ9bt1o8qK1vUzu6xmv5M2vH3zxe4K/t55718mxZX+ybu3wcP4HzjVqNMD/DfqctX+35VTvfrBn47/K7/pt+VWWith5pTvl8mEVMK/8C+a2/H4/z2fysjc9nKT/629F9Pl1/Tyt+0Y4159O0Xz+rt6u/Y008+7ufHzvphbX+DPbF3fkO8rXiF4L+oc60/Mba/ZEINAP/cl4Btwf5Tqsnbs5XBn5rs3U17Z9PtfwWZ/mgjVq8sVlnoHEe2L/Q6M/+KF8Ub9rP369fguMzJf8lfrWLye3dz4fMZj/Fsd/W3w7sb96/Vmc6R416DfRHjkQl3sN+r0vje6r7h3Wm5O/aTxmsC/xMq3/opzj2Yx1a/U371yM7v6bXjsca55f3y0Kjv+mb88UU4o3w/HN8pja+EWpHbb1G5E/k9mV+GcTXznfarx3oO2VORs8VPcM2oB18hW6h0R/aY09Yy5fY0N9oxW/WTCue+3XGd+sJv/52GPDb+Ugvgtne0crfmadWn/FoPWE/js/01sN+rGHvft46n26dYb+BWlFvGp/7Ux4QjWfzsHxb+9/pDOrDOnX379RGbT0WAh3mz7DfP98wXiL7sY5mjVp+9Pf5Fji+0P+GIB7rDsuE+QPNjB5vIfAvOlPy7/KJeAbaz9PD/RcmXTrfS/8c7/tX4yf8OqM9rB8WtPyZVr5unbH5+LrhT3Nz7bV8Z7vjIQE74c8X5uv9iUBH+bE+a+tZqxda/kzJ788j9uXW8RbN5HY/Tlpn0Mp3Ug3WPB8S1H+rf9EZ9vPrkelE9lu9qfZ83mv50R+5bJ6tehbYny3G39qf9UJnfK2/XxePP8+Lv9DfCMfL9NTXNV4G/X28WdAaL9wvmVJ/rNOa+qLxF51h/0LWPK7F+3kPq6dTg7Qmrg74bT19e2++GrooczLCK3YtzbTiC/1s4639RIhpxW/WTCue+3XGd+tM5LcrpumF0NkbOF+gW3nC/hnT9mLBee7g/tmG43N8pqeeBPuD+AXnf2Q+a8dn/wLHB5qJ4m0eNq+t/e90xrRfp7XP75ZeqPjTm1Y+FoL4RWda45fG86zNv8DxrJkgnvepWU+YP9DYJ8jj/Wj34zGt/AuBf9GZkn+XT8Qz0L3zW+B8nf4wfoLPq9nu/i1/ppWvW2dM+3r964Fvx3O1lO/MdzwsVPx4LcIcE0H80Xqh5c+U/P48wm4db9FMbudxzCZa+U6qFybt51V7PiQK/Y21/kVnWuOF+TPD8jNBvK1XWquN/VkvdMa3+pfg/Ws26h+Ol2nVgztg/HgJygPQn+tDv9Z4oc5Efj+OP5/Mo+MtZI1xwdb1atbTqRcm7evwrwe+vfXv6x70nTIn4pFPoJju/gQ23Nb+8PMVTd8/jVHwp41eiC8BP/Jw/KIzod/pNeu/0Bm/zDfTio8054niFwp+vKB4OH9r/DXj3RD4w/hMLb42n97xWC+wP9Odj6nE++fFlv6Jyfr1iPKV+m96/cmU/FZHesOaju5P5GBB4K+NZ+ATjNX5M7Xx/PoC+HufPwvkH6lLdfbGt/IvBP7ROjyfjPNbPPbDsu5Bfx6vFb/g/MX6WGda/gX2b9Qgej3g+S4E+U6rMyU/9oMda1+PTKdYXj+KN7/F1eKr42Va/oWO/g+Nly2efzYnI4qvrc/Rd1g9sv7oB/8Cxwf9N/sprjme0/78bH7/a8VnavF+3bf0N0yn+jMlf9d+ykCn2lxe4Pvf7I9MmJ/i1tbD+xP12flLcH/q1xwv0AtZ+3w388920Qz7A71Afsw3jM/Az+t1R27nfJt1JtrPUT2lfGm/dqBfXzoRa359iUlXEAN/eqHO/fkFCf2sneOgLZ/FwWKcUhyI4r3dUmdtnNJ4pXkZpbrW/DoA5y35PRgv6leL99Ty8PyxThbn80Cjf7SetfH9uDwe8PWV6o36GbV5oh34+ZTiW/Pxfp+/NS7wcaX86B+tD4/P9a6dF8f7cXme3m75dQyerxHNCzZq97Y13574R9u3rm/Uz/DtPH40v9q82R/VWRqvFu/zlsaP8pnd81dWfL0AdTNcn82Daa0r4+PZ78fjekr9SnUjrra+nMfj+3uiunva2e55fh+1tX1g8yvNa0078lu7Xy8Q5fFE59XHIX9pfD8fT097LR+0URo/6u9hv7fP2jfRepi/Vr/vF827NN/WeF5HthRXWv9afKud4To90boY6Mf1eY06SvVwHIjiYXv2UzSegfZoPlH8mnFK58uPZ36OK/Xz62K04mvt3g8szsfzeUA/P0/f3/DtPG5pfdjPlMYp1WlxpfylOjgfKM3b8P25jlY7W9uvPddXdFHmRNj6/9/HH26up9lXA11V2wa3K76j8hl76k/f3tb6G1s0bhmEHp1f+pW9NN6k1vTX/pde/nGT2ZLvv799mfbR50Wv7S/9yhm1zu8r0v1a7y/Sa3Xt/Uj7SfpK2vbr6p/EFs9n7d+8Sc9WejbSs333OjMsn3TireuFzviSvsSvrEgntmid3wnphPRspWczWi90xkvPVno2Z9M96DtlTsTRf3Ob2FGnK9wVf+JE+q2tf2KDTndYVPyG9GzPqlt/k1zS2v8T71zjU8lR+aRnIz1b6dm8R633lwnpRK+uvR9pP01IJ66g037t4OaiTO/vaIt90CdQE0/UWv8J6cR71Nr/E9IJ6dlKz0Z6ttKz2aL1/jIhnRihtZ8mpBNX0Gm/dnD3nTLpyo4lsis7Hz+9fP2WN7707prt6PzSdc12dH5p6TNrtqPzS78PzXZ0funnaraj80u/Tc12dH7p96XZjs4vLT1Sm930Rb///mKdpkTpVhvZI+2Pn/VFy89EX3Qt3jPa/2IE2kdvG51fsQXtGzES7SdxJXr36/13ytiVncmmKzyG9GG692/OxD5o/cV7RvtfCCHEHuj9RYxE+0lcid79ev+dMh+t43xrakL6MN37N2diH7T+4j2j/S+EEGIP9P4iRqL9JK5E7369+0nsEXd8SG/VQgghxHXRJ5hvG51fIYQQYjx3F2VG3PEhvVXf8uHDh+U4mj3HfMZ8hBDreKuvP1ejthZnXCf+RAh76Bm1nnF9ro7OrxiB9k2bZ63P0YyYI9bqGev1Hs6R573N90iq3ynz09/+Mh0fkn3sDpAx2uoYme9o3VrP0idQ9j3M7ruYb1549npiWF6MyePZsRd75ga1ufR+Asg5cAhxZa78+hO1R3BOf0R+tDOlNiaKqeV9NlZTqa6ovcaz9xGIxuV27wMtf8TWfhEjcpR4JO+zzy+PZ0eJqD0iyoU2+P1RoifGsyZ2D3jcEXWc8f0FjBr3kb6M5eL1KeHr5iPyo50ptTE+D469qOU+879XmN6x19SIsUrHUYwae2u/Nayt89GauH/v/182v1Pm51/+nI4/kk4XFf4+X1j4x2QTFH9GHdWbLvIU4vfSto62nkbJ3/qbMzvJeNHB8ejG6eGoMS33npTWz9P7N38G5+FcQlyNq77+oK41tfh8JW34NrSb9eNg7EcZkeMqYM38sebcbaU1bs23teat/a7Ms+bcGhN1ja6ld1x/tEBMT+wRjKjjrO8vW87PmeC6WRu+De1m/fpiHXrwuTjPSGr1nHU/HYWfV0kfhR9369h717xlL4yuqff/LxvfKXOv//kvu7AwHZON7vjYT3M9K/onBubbRa8HG6e0wdBm1h/c5jG9ZjP6PKVckc8DX8ni8Pj2kr+ExWx5kvncveN4oL3FAUoxwD8W4mw8+/XnreDXwa+Nbze2+PC45Gth54Jz8fnhnL2fCHn23kesQakNmI/zemp9a3Bd/vCUfN7isQFdavd2K77/Gc/vnrT2AePjR9Xp8+Hw+Hbvq7XDtnx47C3wGvE4RrD3vmHN+Dx2eLjdWzxugVjug8fcfgVQc6n2ms8DX2S3svd+MkxznMfn8nF4zO1b8fkAcnObJ4rnuBqlWN/GOSMft8Oyr4bFlZ7jvq2UE4+95Zg9aHynTL+2O2jsWpDdkeLvQIHGHTZRPLT34w6X13zzeKV8GC/SdofKffxt/ffjzf2h4U8UNM9nTX2z3g/bgDhsU7HeAufxuWo+D+IY7l/Luxe+tqhOxmK4VsC1I87wsd7HcUJcEex57GfWVwI1Yx4j4bXx+df6rA2w3/seBTnBmjsO18JzYH0luH4/h5LP8BaPa3kM+LfC/XV+n0O0HtxuR9Tu1zDKZ49h8bhFa6y94XFZb6E2J/YZ3uJxjVp+9Ef7XmBM1PIotTnVfJ6olqh9D7hG1lvhXD6fPYbF40fhNUNuO1rzqNX6CJzX0xqT/SPqMVo59xq3RPU7ZRKd2rCLEXYHjV0AgR8ad9jYhYpSvPnTxY+pn1l/R47PZ/1L+er1Tf+QqPo/3Y0354Uf487+dNGFtOXj+cT1letpfQKFzeCPI+AxrY4R1HKNGmMNfv19baU6sRb+aFGbE/tMI6d/LMReXPH1x+vRzxM/5oi8nG9Ezl78mj2bZ+0jz9qxt9Z8hrkefe6fNWce08/ba9S3hi19RuPnM4It+fw68Bq3OOv7y3tg9LpyvlF7s5aL28+8nzD2s+k5L75Wsz19PFhbHHuytrYSW2odMW5rv4Lmd8qw9neUJLLfsIsQrf4zrfhpAjf61W8XPEr5onifL10kSXW34vMFEyO3z+NOBDrMlyjXk3DxPZ9A2ebwx95PAmOPMS2H5ToTaz4B5DXxc7HHZ5yfEDXe0+tPDzzuo3C+ETk9ti7+GIXViZylmreM59cA+Y8E467B12tHb821flg7HG+F2pz3Yu8xj5rHSLCvcOxJa6yzvr9sAbWdtT6G1/VRON+IdbAca2o7+36KxrM2fxzJ2nF9fNSH17gF1iXKtzelOltzHEHv/18+9J0yN3eUJO7vQDE/7iwxe0vfHSSv+t6/UIy/11Z/qiO3w1+us53vVkd5Jjr7vxfwxDwrvr61tVrso/NDDn4shLjFnh84jgDPx0ef46NBTf7YG78WoPcTIfGcc/YoVz2/eI0403N2b47cX0eOdQYwxyvvJ//6/ex5XH0te8F6++MI/LnuHdPHr+nXArnOcL63rMuePPidMnwh4faOELswYRdu0kWcbG/pu4PkVVfGL8a39JzPLp6U61yfj/OYTXT2r7FmA1/hxW3Ek7K3/5axfJ8RtfZi4+DFwT8W4pms2f9HPFfw3ODjiLGPojaX1jxHrgPWtofWJ0Jr6ho1hy37wuIx5611bBnz7Jzx/NawMbB//bFl7J5+GM/YOs5ejKgFc8IcI9aOtSZ+1Jqe7fy8d0aej2fsJ6ZnPmfYf3s9p8Ez53i15/jj3ymTcBcUKvH+DpSFYvz0xn+j2+PX42/z2YUSu2AEbXj//R0uXE9Lv44/j1OvB/4tfyOJJxH7Wk+uiNIG9nl9bh6z1+dBXC+ct5QzolSTp7T+Pr9/zHmQyyziMB7wsT6OicYUYk+u9vrzDHj8Ur2PgHylua7xsX8v/Li91Gpl39Y5II+nNK6HfX7sUt+e2mr91vqA97HGgTxr4TwG8vdSq4d9W+ss1eTzPpJ7La1xec52tEBMT2yUv9Teuya+bw89Y531/aU0btSOcUtthu/Topb/CHg81NODr9nnqc2p5vMgrsVZ91ONWk2G94+Gx27RqrUG9/X9onbjkTFrlPIC9o3E52vtV/DQd8rgDhPzL7h4u1PEx/s7UBYov2mL6/4Vo0Rc76ynBSH/wqR5vNc6J4r9y5rn69enVY/pLX8j6eF2tqClPebjw7PFV4orWQ/3x7EW35f79/7NH+fAAZ/Hax/L7UI8m6u9/vjHnqg9ohS/JnfPeK183m+PcUCDXh+3M6U2phbD+XvyedCn1Jfb2YKWLmExfNTaPS1/RK3foz7g47i9F87h+/rHPUR5DG5nC1raYz4+gH/sido9pRifH4/9UaInxsOxpT6+zcf3tjPc5vuUfAzicTBnfH8BFuMP0NPORO0lfB7u05vDU+oT5VkT67EYPjxbfKW4kvWc9d8rjLX5dmhuB1F7jSgPg9w4PGvi8di3MdzPW99u8ONWDCi1RficOECpna2n1Mb4XEbv/19+mDotvX797deXX37//PLp4yS+TYddKLA7OKQP0T9+9+Xlh+9/mIR4Brb/tf7ivaL9L0bw5bcvL5+//5yVeGvo/Iot6P1FjET7SVyJ3v3a+E4Zu2AgfZwWQgghrkvvJ0Limuj8CiGEEOO5uVPGPgGZ79yY7+B4yXdwSB+j2Y7OL13XbEfnl5Y+s2Y7Or/0+9BsR+eXfq5mOzq/9NvUbEfnl35fmu3o/NLSo3X7TpmXl/8HbEP0Ax6CvqQAAAAASUVORK5CYII=

    Cheers,

    Dave

  • Sue_H

    SSC Guru

    Points: 89718

    david_h_edmonds - Thursday, March 28, 2019 7:53 AM

    Hi, apologies if I am asking a question that has been asked many times but I can't find the answer that I need.

    I have a matrix in ssrs and I am wanting to add a column into it that shows a value as a perentage of the row total as you can do in excel as follows:

    I have tried sum(iff()
    I have tried sum/sum
    I have tried helper fields and I still can't get it going.
    Does anyone have a way to explain this for me please?
    Expr for the field is:
    =sum(Fields!Booking_Count.Value,"matrix1_Booking_Channel")/sum(Fields!Booking_Count.Value)
    My matrix is as follows:

    data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAABGUAAABCCAYAAAD+DGvDAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAB5jSURBVHhe7Z2xsuQ2kkVfb7TR8wfrtqEIyR1zTZljzJfInM8YU18yhswx1xxXipDRv7Ce2ugILRPE5cu6hQRAFsgi37sngsq6yEQiAaKqWiy+qg9/TrwIIYQQQgghhBBCiEP5r2yFEEIIIYQQQgghxIHooowQQgghhBBCCCHEE9BFGSGEEEIIIYQQQognoIsyQgghhBBCCCGEEE9AF2WEEEIIIYQQQgghnoAuygghhBBCCCGEEEI8gZufxP71t19fXr5NDz5Ox2Q/ffz08vXbV+mDNNvR+aWlpaWlpaWlpaWlpaWlpffXZn/4/ofpQZ27izI9ncQ+2Pr/+4ut/3QiXz7JysrKysrKysrKysrKyspe0P74ue/6ys2fL31KCcSzSOtvV9Ymm66wGdLS0tLS0tLS0tLS0tLS0pfSvddXdKfMidCdMrKysrKysrKysrKysrKy17eb7pQRz2fEFTlpaWlpaWlpaWlpaWlpaeln6j50p8yJ0J0ysrKysrKysrKysrKysrLXt/pOmQvC3ynz09/+Mh0fkn3sCl2sLf/IfKP0XNerHp1/rfb1+POyNZ+0tLS0tLS0tLS0tLT029X6TpkLwnfK2P/4//yLnZ5X7fn5lz+m/95fkVtj7cJClIfH38OmCxsOjFer6xm2VM8R6yMrKysrKysrKysrKyt7PavvlLkot1fY7vU///VHujjw82TtQkHPFbqaXij47YLDo/lr2ur387Hxbi88jR3vIZ1gP5+fB/JLS0tLS0tLS0tLS0tLvyHdh+6UORE9d8q0tMff2dF7R4rXyO8tqI1reH/J8riR39e9Zj6lfmvnweN57fNBy8rKysrKysrKysrKysqa1XfKXBD+TplEp54vELzecWJ3oKQLE5PfbM8dKenCw+S/zz9/90ypPy5M+PxGq96Fih/18HzMX5sPz9c08nO9c7/6+vXUKy0tLS0tLS0tLS0tLS0N3Xt95eaizNd0RUc8i7T+H+3ETScw2QnSP/19/pLZf0w2kf0Lxf7TtrjRfJ6/pnx2USLqbxcqEkH/1njh+BV/XE8l34T1u/W/1jPPw/VP9NWTCPzS0tLS0tLS0tLS0tLS0tC911f0nTIn4/YK272u3SFyf4WO+zt/Yt44uCNla/8E+1s6sdb/Wo/N2+qGnWnVcz8fj8+Hde2tpzyetLS0tLS0tLS0tLS09PvUfeiizMm4vcLW0nyi+QrdffyiE3N/u8hjd+Bs7Z9gf0sn1vrnetJFpF/+nC9OZTvTqqe+fj4fbE89iZxPWlpaWlpaWlpaWlpaWroXfafMidj0nTIJd96K8dP2uNF8nufvaEl3nGzsD//dHSY5nnU03tx/3XxSnhva9S86UR7P17fA/aWlpaWlpaWlpaWlpZOdkJbOuvf6in596UT0/PoSU/PPd5DYRri/cIF+1s5x0Bif6yjFgSg+sr11mfV5fT+LQ3yt35p5GD5Pqx7fLisrKysrKysrKysrK/u+be+vL+mizImw9f/l988vnz5O4ttL+pMiu6ME2m6BSlfcTq7Tlwbbd9QMyndWfdXzIy0tLS0tLS0tLS0tLb2v/vG7L7ooczX4ThlZWVlZWVlZWVlZWVlZWdnr2d47ZfSdMidi03fKSEtLS0tLS0tLS0tLS0tLn0rrO2UuiO6UkZWVlZWVlZWVlZWVlZW9vtV3ylwQW//5b9GmY7L2c1rpipv0IZrt6PzS0mfWbEfnl34fmu3o/NLP1WxH55d+m5rt6PzS70uzHZ1fWnqkNquLMhfD1v/rp2n98wmUPdZ++qr1l32/VvtfdoTVPnrbVudXdovVvpEdabWfZK9kbb/2XF/Rd8qciPk7ZebHX7OVno6JI7TWf0I68R619v+EdEJ6ttKzkZ6t9Gy2aL2/TEgnRmjtpwnpxBV02q8d3FyU+Zr+9kk8i7T+dmVtIv2MliGdOEJr/SekE+9Ra/9PSCekZys9G+nZSs9mi9b7y4R0YoTWfpqQTlxBp/3awc1FGfF8RlyRS0gnpGcrPRvp2UrPRnq2I7U+wZx4w1rnd0I6IT1b6dlIz1Z6NtKzhe5BF2VOxogrcgnphPRspWcjPVvp2UjPdqTWJ5gTb1jr/E5IJ6RnKz0b6dlKz0Z6ttA96DtlTsQzP4H66+cP84PO+Leo9QngxI76r999SPvM7Ih8iQH62fWcZT20/yc6de318mz725CerfRspGcrPZsjtN5fJibr/x00Ip9xBn30fLSfJiarf29cQ6f92oF+felE9P760vI/BJn//D6dwkp8j7UndpTHxvvPl8lX6PeI3WMeNduax5pvc09vQMTe9a+xtfP5DNvaX56j616zv/m8j3he1MY/8jxu+TWD3vXomQfvA4/ljfyWN8r/SPvW87JmP/VYzDuq1xg5HuzWeez5qxiYL0B93G7wepX2T21+a+N7bG3frLWj91mvPfOvnkT7oxTXOg/R8w7r3rs/OC4a18c947xiXpF+1D5r3/Suf699ZF1q+47r9Nh4kd/yRXlr7Z4R57m2Lj3Pt7W2Zz9hnlxXbz21uNb5KuXbw0brXtsvpTw9do/zaBbnCfSu35Z6avt0T2v7dfWvL4nn03sFzjaiHf87HWlDN+KbOlPyp03P8Q/q9MTI9WMuNo9R+XfXE6euPzMs36M6E/mxhsP2807aQK3pnOONr7P/Wm3rkeiMP1obXeuRqeWz/ng+GTc6x/nnG/yGPebnn+lw/TJcz8KkLWdYbyb0j9YZ9i9w/ABdnX9F7/UJJs4nzn065+4fnqa93++H0vtNign269r4Xr3QGX9GfeZPqI2u85XpyZcI/K39gX2Ew+Kj9zfzG8kW/MaR2uoYmc84Wq9Zf2NvvVDwoz6zxo3OcbzfTBv22L/eWTxeL6GNxT+B/qlv3ret+rdqG8MYla9XL7A/s7n/ZP36GTe6EG8crVEPjnA/dOpH+5e07VNfn9ne/bhHPYmddA+6U+ZErLlTxl/pK2mPbXL0T29IDvTDE8PHQSO/t6A2ruH9Pq7U7m1vnT5frb4on8+z5pOcWh3we3y79YO/J94T5TH8+fJwnIE8pXijNb6fd5SnVg/343qiebbq4njDj1fqh/F8ncjn6/T5a9rj80Tr0Dt/WFAb1/D5QTQvs1s+yURdkTaL+fA8a7aWp6dfqX8prtbO54HxcUzUz7ejThDVG61fqb13vCje4Pl7C9C/VO8en4ij/rV+P+9a/6hfLc6vh+Hjrb+H189AXR5/Xry/tN44L9yO/h4fF53HZ57fURbrFmmzWLfa+tXiWv1b/pr19fo8wOfz7Ybv5+nJV9ovPp7HrfVDHNuj9w3XXbK1+nvXifP6fkbrvHB/jMP+3vlYv1L/UlxNe6J1MdCP6/Oa6/L5a+Ma3u9tz37icbnddG0+nqgOzod2zB95esarrZ8nijPdajdbqxd+4ON6183yeP+aOthG4/j+3oIor58n+31/w8dF8+mZp1nbr6vvlOn9myexDyM+gUobbtqM/gqpbTTzY+N6P294y2dx0RVIzo/+aMfxyBVMjO/zcZ1R/6g+1IN8pf5r1n+h4G/V7/1RvOWzdmiej8F+05bPtAGfEdXD62WH0Rqf1wN5fHytHu4f6gnLg/Hhj+Zj+Pjkm3Q0n6j+JV+hHqOkS/mRp7Y+BvIhjvMbnB/9zfr52gGQj+tZ8rvxN73+ZELN8Z16oTN+0UwQvxD09/Fr1hc+68/nyyzW34jOp8H19ure8aL6AOfHPHEseWn8vfTCWj8T9F87Hq+HP39msZ44rL9Zw8fD33O+EtnWdGl85EXdPB7PZ6mjYzzjNDoTao4/m85A954v8/t2f/5tP7TyoT/69NRb27+l+LPdYVWrH+uEA+322EA850c/+FPfvP7oC3+C+kMvBP5QM0H8QkGvef1IPre/kA9xd/knOD/6m0Ub/KA03679xFD73ufL509M7dBm7Sitn9e8XqlPPh+leKOlFwp+Hu+mvgzmhcPiLQ752B/Wm6nVi/xLrkI9hrUjhuup5TdMc/80Vq47mg/aOb6UP+3XDm4uyvT+jrbYhzW/avA/0wayTZQ23sTiz7T6czzAxozi05XAiah/c7yNmonio/pa+U2vWX8D62+HnQ9bt1o8qK1vUzu6xmv5M2vH3zxe4K/t55718mxZX+ybu3wcP4HzjVqNMD/DfqctX+35VTvfrBn47/K7/pt+VWWith5pTvl8mEVMK/8C+a2/H4/z2fysjc9nKT/629F9Pl1/Tyt+0Y4159O0Xz+rt6u/Y008+7ufHzvphbX+DPbF3fkO8rXiF4L+oc60/Mba/ZEINAP/cl4Btwf5Tqsnbs5XBn5rs3U17Z9PtfwWZ/mgjVq8sVlnoHEe2L/Q6M/+KF8Ub9rP369fguMzJf8lfrWLye3dz4fMZj/Fsd/W3w7sb96/Vmc6R416DfRHjkQl3sN+r0vje6r7h3Wm5O/aTxmsC/xMq3/opzj2Yx1a/U371yM7v6bXjsca55f3y0Kjv+mb88UU4o3w/HN8pja+EWpHbb1G5E/k9mV+GcTXznfarx3oO2VORs8VPcM2oB18hW6h0R/aY09Yy5fY0N9oxW/WTCue+3XGd+sJv/52GPDb+Ugvgtne0crfmadWn/FoPWE/js/01sN+rGHvft46n26dYb+BWlFvGp/7Ux4QjWfzsHxb+9/pDOrDOnX379RGbT0WAh3mz7DfP98wXiL7sY5mjVp+9Pf5Fji+0P+GIB7rDsuE+QPNjB5vIfAvOlPy7/KJeAbaz9PD/RcmXTrfS/8c7/tX4yf8OqM9rB8WtPyZVr5unbH5+LrhT3Nz7bV8Z7vjIQE74c8X5uv9iUBH+bE+a+tZqxda/kzJ788j9uXW8RbN5HY/Tlpn0Mp3Ug3WPB8S1H+rf9EZ9vPrkelE9lu9qfZ83mv50R+5bJ6tehbYny3G39qf9UJnfK2/XxePP8+Lv9DfCMfL9NTXNV4G/X28WdAaL9wvmVJ/rNOa+qLxF51h/0LWPK7F+3kPq6dTg7Qmrg74bT19e2++GrooczLCK3YtzbTiC/1s4639RIhpxW/WTCue+3XGd+tM5LcrpumF0NkbOF+gW3nC/hnT9mLBee7g/tmG43N8pqeeBPuD+AXnf2Q+a8dn/wLHB5qJ4m0eNq+t/e90xrRfp7XP75ZeqPjTm1Y+FoL4RWda45fG86zNv8DxrJkgnvepWU+YP9DYJ8jj/Wj34zGt/AuBf9GZkn+XT8Qz0L3zW+B8nf4wfoLPq9nu/i1/ppWvW2dM+3r964Fvx3O1lO/MdzwsVPx4LcIcE0H80Xqh5c+U/P48wm4db9FMbudxzCZa+U6qFybt51V7PiQK/Y21/kVnWuOF+TPD8jNBvK1XWquN/VkvdMa3+pfg/Ws26h+Ol2nVgztg/HgJygPQn+tDv9Z4oc5Efj+OP5/Mo+MtZI1xwdb1atbTqRcm7evwrwe+vfXv6x70nTIn4pFPoJju/gQ23Nb+8PMVTd8/jVHwp41eiC8BP/Jw/KIzod/pNeu/0Bm/zDfTio8054niFwp+vKB4OH9r/DXj3RD4w/hMLb42n97xWC+wP9Odj6nE++fFlv6Jyfr1iPKV+m96/cmU/FZHesOaju5P5GBB4K+NZ+ATjNX5M7Xx/PoC+HufPwvkH6lLdfbGt/IvBP7ROjyfjPNbPPbDsu5Bfx6vFb/g/MX6WGda/gX2b9Qgej3g+S4E+U6rMyU/9oMda1+PTKdYXj+KN7/F1eKr42Va/oWO/g+Nly2efzYnI4qvrc/Rd1g9sv7oB/8Cxwf9N/sprjme0/78bH7/a8VnavF+3bf0N0yn+jMlf9d+ykCn2lxe4Pvf7I9MmJ/i1tbD+xP12flLcH/q1xwv0AtZ+3w388920Qz7A71Afsw3jM/Az+t1R27nfJt1JtrPUT2lfGm/dqBfXzoRa359iUlXEAN/eqHO/fkFCf2sneOgLZ/FwWKcUhyI4r3dUmdtnNJ4pXkZpbrW/DoA5y35PRgv6leL99Ty8PyxThbn80Cjf7SetfH9uDwe8PWV6o36GbV5oh34+ZTiW/Pxfp+/NS7wcaX86B+tD4/P9a6dF8f7cXme3m75dQyerxHNCzZq97Y13574R9u3rm/Uz/DtPH40v9q82R/VWRqvFu/zlsaP8pnd81dWfL0AdTNcn82Daa0r4+PZ78fjekr9SnUjrra+nMfj+3uiunva2e55fh+1tX1g8yvNa0078lu7Xy8Q5fFE59XHIX9pfD8fT097LR+0URo/6u9hv7fP2jfRepi/Vr/vF827NN/WeF5HthRXWv9afKud4To90boY6Mf1eY06SvVwHIjiYXv2UzSegfZoPlH8mnFK58uPZ36OK/Xz62K04mvt3g8szsfzeUA/P0/f3/DtPG5pfdjPlMYp1WlxpfylOjgfKM3b8P25jlY7W9uvPddXdFHmRNj6/9/HH26up9lXA11V2wa3K76j8hl76k/f3tb6G1s0bhmEHp1f+pW9NN6k1vTX/pde/nGT2ZLvv799mfbR50Wv7S/9yhm1zu8r0v1a7y/Sa3Xt/Uj7SfpK2vbr6p/EFs9n7d+8Sc9WejbSs333OjMsn3TireuFzviSvsSvrEgntmid3wnphPRspWczWi90xkvPVno2Z9M96DtlTsTRf3Ob2FGnK9wVf+JE+q2tf2KDTndYVPyG9GzPqlt/k1zS2v8T71zjU8lR+aRnIz1b6dm8R633lwnpRK+uvR9pP01IJ66g037t4OaiTO/vaIt90CdQE0/UWv8J6cR71Nr/E9IJ6dlKz0Z6ttKz2aL1/jIhnRihtZ8mpBNX0Gm/dnD3nTLpyo4lsis7Hz+9fP2WN7707prt6PzSdc12dH5p6TNrtqPzS78PzXZ0funnaraj80u/Tc12dH7p96XZjs4vLT1Sm930Rb///mKdpkTpVhvZI+2Pn/VFy89EX3Qt3jPa/2IE2kdvG51fsQXtGzES7SdxJXr36/13ytiVncmmKzyG9GG692/OxD5o/cV7RvtfCCHEHuj9RYxE+0lcid79ev+dMh+t43xrakL6MN37N2diH7T+4j2j/S+EEGIP9P4iRqL9JK5E7369+0nsEXd8SG/VQgghxHXRJ5hvG51fIYQQYjx3F2VG3PEhvVXf8uHDh+U4mj3HfMZ8hBDreKuvP1ejthZnXCf+RAh76Bm1nnF9ro7OrxiB9k2bZ63P0YyYI9bqGev1Hs6R573N90iq3ynz09/+Mh0fkn3sDpAx2uoYme9o3VrP0idQ9j3M7ruYb1549npiWF6MyePZsRd75ga1ufR+Asg5cAhxZa78+hO1R3BOf0R+tDOlNiaKqeV9NlZTqa6ovcaz9xGIxuV27wMtf8TWfhEjcpR4JO+zzy+PZ0eJqD0iyoU2+P1RoifGsyZ2D3jcEXWc8f0FjBr3kb6M5eL1KeHr5iPyo50ptTE+D469qOU+879XmN6x19SIsUrHUYwae2u/Nayt89GauH/v/182v1Pm51/+nI4/kk4XFf4+X1j4x2QTFH9GHdWbLvIU4vfSto62nkbJ3/qbMzvJeNHB8ejG6eGoMS33npTWz9P7N38G5+FcQlyNq77+oK41tfh8JW34NrSb9eNg7EcZkeMqYM38sebcbaU1bs23teat/a7Ms+bcGhN1ja6ld1x/tEBMT+wRjKjjrO8vW87PmeC6WRu+De1m/fpiHXrwuTjPSGr1nHU/HYWfV0kfhR9369h717xlL4yuqff/LxvfKXOv//kvu7AwHZON7vjYT3M9K/onBubbRa8HG6e0wdBm1h/c5jG9ZjP6PKVckc8DX8ni8Pj2kr+ExWx5kvncveN4oL3FAUoxwD8W4mw8+/XnreDXwa+Nbze2+PC45Gth54Jz8fnhnL2fCHn23kesQakNmI/zemp9a3Bd/vCUfN7isQFdavd2K77/Gc/vnrT2AePjR9Xp8+Hw+Hbvq7XDtnx47C3wGvE4RrD3vmHN+Dx2eLjdWzxugVjug8fcfgVQc6n2ms8DX2S3svd+MkxznMfn8nF4zO1b8fkAcnObJ4rnuBqlWN/GOSMft8Oyr4bFlZ7jvq2UE4+95Zg9aHynTL+2O2jsWpDdkeLvQIHGHTZRPLT34w6X13zzeKV8GC/SdofKffxt/ffjzf2h4U8UNM9nTX2z3g/bgDhsU7HeAufxuWo+D+IY7l/Luxe+tqhOxmK4VsC1I87wsd7HcUJcEex57GfWVwI1Yx4j4bXx+df6rA2w3/seBTnBmjsO18JzYH0luH4/h5LP8BaPa3kM+LfC/XV+n0O0HtxuR9Tu1zDKZ49h8bhFa6y94XFZb6E2J/YZ3uJxjVp+9Ef7XmBM1PIotTnVfJ6olqh9D7hG1lvhXD6fPYbF40fhNUNuO1rzqNX6CJzX0xqT/SPqMVo59xq3RPU7ZRKd2rCLEXYHjV0AgR8ad9jYhYpSvPnTxY+pn1l/R47PZ/1L+er1Tf+QqPo/3Y0354Uf487+dNGFtOXj+cT1letpfQKFzeCPI+AxrY4R1HKNGmMNfv19baU6sRb+aFGbE/tMI6d/LMReXPH1x+vRzxM/5oi8nG9Ezl78mj2bZ+0jz9qxt9Z8hrkefe6fNWce08/ba9S3hi19RuPnM4It+fw68Bq3OOv7y3tg9LpyvlF7s5aL28+8nzD2s+k5L75Wsz19PFhbHHuytrYSW2odMW5rv4Lmd8qw9neUJLLfsIsQrf4zrfhpAjf61W8XPEr5onifL10kSXW34vMFEyO3z+NOBDrMlyjXk3DxPZ9A2ebwx95PAmOPMS2H5ToTaz4B5DXxc7HHZ5yfEDXe0+tPDzzuo3C+ETk9ti7+GIXViZylmreM59cA+Y8E467B12tHb821flg7HG+F2pz3Yu8xj5rHSLCvcOxJa6yzvr9sAbWdtT6G1/VRON+IdbAca2o7+36KxrM2fxzJ2nF9fNSH17gF1iXKtzelOltzHEHv/18+9J0yN3eUJO7vQDE/7iwxe0vfHSSv+t6/UIy/11Z/qiO3w1+us53vVkd5Jjr7vxfwxDwrvr61tVrso/NDDn4shLjFnh84jgDPx0ef46NBTf7YG78WoPcTIfGcc/YoVz2/eI0403N2b47cX0eOdQYwxyvvJ//6/ex5XH0te8F6++MI/LnuHdPHr+nXArnOcL63rMuePPidMnwh4faOELswYRdu0kWcbG/pu4PkVVfGL8a39JzPLp6U61yfj/OYTXT2r7FmA1/hxW3Ek7K3/5axfJ8RtfZi4+DFwT8W4pms2f9HPFfw3ODjiLGPojaX1jxHrgPWtofWJ0Jr6ho1hy37wuIx5611bBnz7Jzx/NawMbB//bFl7J5+GM/YOs5ejKgFc8IcI9aOtSZ+1Jqe7fy8d0aej2fsJ6ZnPmfYf3s9p8Ez53i15/jj3ymTcBcUKvH+DpSFYvz0xn+j2+PX42/z2YUSu2AEbXj//R0uXE9Lv44/j1OvB/4tfyOJJxH7Wk+uiNIG9nl9bh6z1+dBXC+ct5QzolSTp7T+Pr9/zHmQyyziMB7wsT6OicYUYk+u9vrzDHj8Ur2PgHylua7xsX8v/Li91Gpl39Y5II+nNK6HfX7sUt+e2mr91vqA97HGgTxr4TwG8vdSq4d9W+ss1eTzPpJ7La1xec52tEBMT2yUv9Teuya+bw89Y531/aU0btSOcUtthu/Topb/CHg81NODr9nnqc2p5vMgrsVZ91ONWk2G94+Gx27RqrUG9/X9onbjkTFrlPIC9o3E52vtV/DQd8rgDhPzL7h4u1PEx/s7UBYov2mL6/4Vo0Rc76ynBSH/wqR5vNc6J4r9y5rn69enVY/pLX8j6eF2tqClPebjw7PFV4orWQ/3x7EW35f79/7NH+fAAZ/Hax/L7UI8m6u9/vjHnqg9ohS/JnfPeK183m+PcUCDXh+3M6U2phbD+XvyedCn1Jfb2YKWLmExfNTaPS1/RK3foz7g47i9F87h+/rHPUR5DG5nC1raYz4+gH/sido9pRifH4/9UaInxsOxpT6+zcf3tjPc5vuUfAzicTBnfH8BFuMP0NPORO0lfB7u05vDU+oT5VkT67EYPjxbfKW4kvWc9d8rjLX5dmhuB1F7jSgPg9w4PGvi8di3MdzPW99u8ONWDCi1RficOECpna2n1Mb4XEbv/19+mDotvX797deXX37//PLp4yS+TYddKLA7OKQP0T9+9+Xlh+9/mIR4Brb/tf7ivaL9L0bw5bcvL5+//5yVeGvo/Iot6P1FjET7SVyJ3v3a+E4Zu2AgfZwWQgghrkvvJ0Limuj8CiGEEOO5uVPGPgGZ79yY7+B4yXdwSB+j2Y7OL13XbEfnl5Y+s2Y7Or/0+9BsR+eXfq5mOzq/9NvUbEfnl35fmu3o/NLSo3X7TpmXl/8HbEP0Ax6CvqQAAAAASUVORK5CYII=

    Cheers,

    Dave

    Percent of the row total would just be the count/total count in the row * 100. I can't tell where the total count is on your matrix, if there are multiple rows with a totals row, grouped by channel, branch or however it's set up.
    In your first example, the expression for the Blue percent of row would be the blue count / total count for all the colors in the row * 100.
    =Sum(Fields!BlueCount.Value)/Sum(Fields!BlueCount.Value + Fields!OtherCount.Value + Fields!RedCount.Value + Fields!YellowCount.Value)*100

    Sue

  • david_h_edmonds

    Ten Centuries

    Points: 1232

    Sue_H - Thursday, March 28, 2019 7:14 PM

    david_h_edmonds - Thursday, March 28, 2019 7:53 AM

    Hi, apologies if I am asking a question that has been asked many times but I can't find the answer that I need.

    I have a matrix in ssrs and I am wanting to add a column into it that shows a value as a perentage of the row total as you can do in excel as follows:

    I have tried sum(iff()
    I have tried sum/sum
    I have tried helper fields and I still can't get it going.
    Does anyone have a way to explain this for me please?
    Expr for the field is:
    =sum(Fields!Booking_Count.Value,"matrix1_Booking_Channel")/sum(Fields!Booking_Count.Value)
    My matrix is as follows:

    data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAABGUAAABCCAYAAAD+DGvDAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAB5jSURBVHhe7Z2xsuQ2kkVfb7TR8wfrtqEIyR1zTZljzJfInM8YU18yhswx1xxXipDRv7Ce2ugILRPE5cu6hQRAFsgi37sngsq6yEQiAaKqWiy+qg9/TrwIIYQQQgghhBBCiEP5r2yFEEIIIYQQQgghxIHooowQQgghhBBCCCHEE9BFGSGEEEIIIYQQQognoIsyQgghhBBCCCGEEE9AF2WEEEIIIYQQQgghnoAuygghhBBCCCGEEEI8gZufxP71t19fXr5NDz5Ox2Q/ffz08vXbV+mDNNvR+aWlpaWlpaWlpaWlpaWlpffXZn/4/ofpQZ27izI9ncQ+2Pr/+4ut/3QiXz7JysrKysrKysrKysrKyspe0P74ue/6ys2fL31KCcSzSOtvV9Ymm66wGdLS0tLS0tLS0tLS0tLS0pfSvddXdKfMidCdMrKysrKysrKysrKysrKy17eb7pQRz2fEFTlpaWlpaWlpaWlpaWlpaeln6j50p8yJ0J0ysrKysrKysrKysrKysrLXt/pOmQvC3ynz09/+Mh0fkn3sCl2sLf/IfKP0XNerHp1/rfb1+POyNZ+0tLS0tLS0tLS0tLT029X6TpkLwnfK2P/4//yLnZ5X7fn5lz+m/95fkVtj7cJClIfH38OmCxsOjFer6xm2VM8R6yMrKysrKysrKysrKyt7PavvlLkot1fY7vU///VHujjw82TtQkHPFbqaXij47YLDo/lr2ur387Hxbi88jR3vIZ1gP5+fB/JLS0tLS0tLS0tLS0tLvyHdh+6UORE9d8q0tMff2dF7R4rXyO8tqI1reH/J8riR39e9Zj6lfmvnweN57fNBy8rKysrKysrKysrKysqa1XfKXBD+TplEp54vELzecWJ3oKQLE5PfbM8dKenCw+S/zz9/90ypPy5M+PxGq96Fih/18HzMX5sPz9c08nO9c7/6+vXUKy0tLS0tLS0tLS0tLS0N3Xt95eaizNd0RUc8i7T+H+3ETScw2QnSP/19/pLZf0w2kf0Lxf7TtrjRfJ6/pnx2USLqbxcqEkH/1njh+BV/XE8l34T1u/W/1jPPw/VP9NWTCPzS0tLS0tLS0tLS0tLS0tC911f0nTIn4/YK272u3SFyf4WO+zt/Yt44uCNla/8E+1s6sdb/Wo/N2+qGnWnVcz8fj8+Hde2tpzyetLS0tLS0tLS0tLS09PvUfeiizMm4vcLW0nyi+QrdffyiE3N/u8hjd+Bs7Z9gf0sn1vrnetJFpF/+nC9OZTvTqqe+fj4fbE89iZxPWlpaWlpaWlpaWlpaWroXfafMidj0nTIJd96K8dP2uNF8nufvaEl3nGzsD//dHSY5nnU03tx/3XxSnhva9S86UR7P17fA/aWlpaWlpaWlpaWlpZOdkJbOuvf6in596UT0/PoSU/PPd5DYRri/cIF+1s5x0Bif6yjFgSg+sr11mfV5fT+LQ3yt35p5GD5Pqx7fLisrKysrKysrKysrK/u+be+vL+mizImw9f/l988vnz5O4ttL+pMiu6ME2m6BSlfcTq7Tlwbbd9QMyndWfdXzIy0tLS0tLS0tLS0tLb2v/vG7L7ooczX4ThlZWVlZWVlZWVlZWVlZWdnr2d47ZfSdMidi03fKSEtLS0tLS0tLS0tLS0tLn0rrO2UuiO6UkZWVlZWVlZWVlZWVlZW9vtV3ylwQW//5b9GmY7L2c1rpipv0IZrt6PzS0mfWbEfnl34fmu3o/NLP1WxH55d+m5rt6PzS70uzHZ1fWnqkNquLMhfD1v/rp2n98wmUPdZ++qr1l32/VvtfdoTVPnrbVudXdovVvpEdabWfZK9kbb/2XF/Rd8qciPk7ZebHX7OVno6JI7TWf0I68R619v+EdEJ6ttKzkZ6t9Gy2aL2/TEgnRmjtpwnpxBV02q8d3FyU+Zr+9kk8i7T+dmVtIv2MliGdOEJr/SekE+9Ra/9PSCekZys9G+nZSs9mi9b7y4R0YoTWfpqQTlxBp/3awc1FGfF8RlyRS0gnpGcrPRvp2UrPRnq2I7U+wZx4w1rnd0I6IT1b6dlIz1Z6NtKzhe5BF2VOxogrcgnphPRspWcjPVvp2UjPdqTWJ5gTb1jr/E5IJ6RnKz0b6dlKz0Z6ttA96DtlTsQzP4H66+cP84PO+Leo9QngxI76r999SPvM7Ih8iQH62fWcZT20/yc6de318mz725CerfRspGcrPZsjtN5fJibr/x00Ip9xBn30fLSfJiarf29cQ6f92oF+felE9P760vI/BJn//D6dwkp8j7UndpTHxvvPl8lX6PeI3WMeNduax5pvc09vQMTe9a+xtfP5DNvaX56j616zv/m8j3he1MY/8jxu+TWD3vXomQfvA4/ljfyWN8r/SPvW87JmP/VYzDuq1xg5HuzWeez5qxiYL0B93G7wepX2T21+a+N7bG3frLWj91mvPfOvnkT7oxTXOg/R8w7r3rs/OC4a18c947xiXpF+1D5r3/Suf699ZF1q+47r9Nh4kd/yRXlr7Z4R57m2Lj3Pt7W2Zz9hnlxXbz21uNb5KuXbw0brXtsvpTw9do/zaBbnCfSu35Z6avt0T2v7dfWvL4nn03sFzjaiHf87HWlDN+KbOlPyp03P8Q/q9MTI9WMuNo9R+XfXE6euPzMs36M6E/mxhsP2807aQK3pnOONr7P/Wm3rkeiMP1obXeuRqeWz/ng+GTc6x/nnG/yGPebnn+lw/TJcz8KkLWdYbyb0j9YZ9i9w/ABdnX9F7/UJJs4nzn065+4fnqa93++H0vtNign269r4Xr3QGX9GfeZPqI2u85XpyZcI/K39gX2Ew+Kj9zfzG8kW/MaR2uoYmc84Wq9Zf2NvvVDwoz6zxo3OcbzfTBv22L/eWTxeL6GNxT+B/qlv3ret+rdqG8MYla9XL7A/s7n/ZP36GTe6EG8crVEPjnA/dOpH+5e07VNfn9ne/bhHPYmddA+6U+ZErLlTxl/pK2mPbXL0T29IDvTDE8PHQSO/t6A2ruH9Pq7U7m1vnT5frb4on8+z5pOcWh3we3y79YO/J94T5TH8+fJwnIE8pXijNb6fd5SnVg/343qiebbq4njDj1fqh/F8ncjn6/T5a9rj80Tr0Dt/WFAb1/D5QTQvs1s+yURdkTaL+fA8a7aWp6dfqX8prtbO54HxcUzUz7ejThDVG61fqb13vCje4Pl7C9C/VO8en4ij/rV+P+9a/6hfLc6vh+Hjrb+H189AXR5/Xry/tN44L9yO/h4fF53HZ57fURbrFmmzWLfa+tXiWv1b/pr19fo8wOfz7Ybv5+nJV9ovPp7HrfVDHNuj9w3XXbK1+nvXifP6fkbrvHB/jMP+3vlYv1L/UlxNe6J1MdCP6/Oa6/L5a+Ma3u9tz37icbnddG0+nqgOzod2zB95esarrZ8nijPdajdbqxd+4ON6183yeP+aOthG4/j+3oIor58n+31/w8dF8+mZp1nbr6vvlOn9myexDyM+gUobbtqM/gqpbTTzY+N6P294y2dx0RVIzo/+aMfxyBVMjO/zcZ1R/6g+1IN8pf5r1n+h4G/V7/1RvOWzdmiej8F+05bPtAGfEdXD62WH0Rqf1wN5fHytHu4f6gnLg/Hhj+Zj+Pjkm3Q0n6j+JV+hHqOkS/mRp7Y+BvIhjvMbnB/9zfr52gGQj+tZ8rvxN73+ZELN8Z16oTN+0UwQvxD09/Fr1hc+68/nyyzW34jOp8H19ure8aL6AOfHPHEseWn8vfTCWj8T9F87Hq+HP39msZ44rL9Zw8fD33O+EtnWdGl85EXdPB7PZ6mjYzzjNDoTao4/m85A954v8/t2f/5tP7TyoT/69NRb27+l+LPdYVWrH+uEA+322EA850c/+FPfvP7oC3+C+kMvBP5QM0H8QkGvef1IPre/kA9xd/knOD/6m0Ub/KA03679xFD73ufL509M7dBm7Sitn9e8XqlPPh+leKOlFwp+Hu+mvgzmhcPiLQ752B/Wm6nVi/xLrkI9hrUjhuup5TdMc/80Vq47mg/aOb6UP+3XDm4uyvT+jrbYhzW/avA/0wayTZQ23sTiz7T6czzAxozi05XAiah/c7yNmonio/pa+U2vWX8D62+HnQ9bt1o8qK1vUzu6xmv5M2vH3zxe4K/t55718mxZX+ybu3wcP4HzjVqNMD/DfqctX+35VTvfrBn47/K7/pt+VWWith5pTvl8mEVMK/8C+a2/H4/z2fysjc9nKT/629F9Pl1/Tyt+0Y4159O0Xz+rt6u/Y008+7ufHzvphbX+DPbF3fkO8rXiF4L+oc60/Mba/ZEINAP/cl4Btwf5Tqsnbs5XBn5rs3U17Z9PtfwWZ/mgjVq8sVlnoHEe2L/Q6M/+KF8Ub9rP369fguMzJf8lfrWLye3dz4fMZj/Fsd/W3w7sb96/Vmc6R416DfRHjkQl3sN+r0vje6r7h3Wm5O/aTxmsC/xMq3/opzj2Yx1a/U371yM7v6bXjsca55f3y0Kjv+mb88UU4o3w/HN8pja+EWpHbb1G5E/k9mV+GcTXznfarx3oO2VORs8VPcM2oB18hW6h0R/aY09Yy5fY0N9oxW/WTCue+3XGd+sJv/52GPDb+Ugvgtne0crfmadWn/FoPWE/js/01sN+rGHvft46n26dYb+BWlFvGp/7Ux4QjWfzsHxb+9/pDOrDOnX379RGbT0WAh3mz7DfP98wXiL7sY5mjVp+9Pf5Fji+0P+GIB7rDsuE+QPNjB5vIfAvOlPy7/KJeAbaz9PD/RcmXTrfS/8c7/tX4yf8OqM9rB8WtPyZVr5unbH5+LrhT3Nz7bV8Z7vjIQE74c8X5uv9iUBH+bE+a+tZqxda/kzJ788j9uXW8RbN5HY/Tlpn0Mp3Ug3WPB8S1H+rf9EZ9vPrkelE9lu9qfZ83mv50R+5bJ6tehbYny3G39qf9UJnfK2/XxePP8+Lv9DfCMfL9NTXNV4G/X28WdAaL9wvmVJ/rNOa+qLxF51h/0LWPK7F+3kPq6dTg7Qmrg74bT19e2++GrooczLCK3YtzbTiC/1s4639RIhpxW/WTCue+3XGd+tM5LcrpumF0NkbOF+gW3nC/hnT9mLBee7g/tmG43N8pqeeBPuD+AXnf2Q+a8dn/wLHB5qJ4m0eNq+t/e90xrRfp7XP75ZeqPjTm1Y+FoL4RWda45fG86zNv8DxrJkgnvepWU+YP9DYJ8jj/Wj34zGt/AuBf9GZkn+XT8Qz0L3zW+B8nf4wfoLPq9nu/i1/ppWvW2dM+3r964Fvx3O1lO/MdzwsVPx4LcIcE0H80Xqh5c+U/P48wm4db9FMbudxzCZa+U6qFybt51V7PiQK/Y21/kVnWuOF+TPD8jNBvK1XWquN/VkvdMa3+pfg/Ws26h+Ol2nVgztg/HgJygPQn+tDv9Z4oc5Efj+OP5/Mo+MtZI1xwdb1atbTqRcm7evwrwe+vfXv6x70nTIn4pFPoJju/gQ23Nb+8PMVTd8/jVHwp41eiC8BP/Jw/KIzod/pNeu/0Bm/zDfTio8054niFwp+vKB4OH9r/DXj3RD4w/hMLb42n97xWC+wP9Odj6nE++fFlv6Jyfr1iPKV+m96/cmU/FZHesOaju5P5GBB4K+NZ+ATjNX5M7Xx/PoC+HufPwvkH6lLdfbGt/IvBP7ROjyfjPNbPPbDsu5Bfx6vFb/g/MX6WGda/gX2b9Qgej3g+S4E+U6rMyU/9oMda1+PTKdYXj+KN7/F1eKr42Va/oWO/g+Nly2efzYnI4qvrc/Rd1g9sv7oB/8Cxwf9N/sprjme0/78bH7/a8VnavF+3bf0N0yn+jMlf9d+ykCn2lxe4Pvf7I9MmJ/i1tbD+xP12flLcH/q1xwv0AtZ+3w388920Qz7A71Afsw3jM/Az+t1R27nfJt1JtrPUT2lfGm/dqBfXzoRa359iUlXEAN/eqHO/fkFCf2sneOgLZ/FwWKcUhyI4r3dUmdtnNJ4pXkZpbrW/DoA5y35PRgv6leL99Ty8PyxThbn80Cjf7SetfH9uDwe8PWV6o36GbV5oh34+ZTiW/Pxfp+/NS7wcaX86B+tD4/P9a6dF8f7cXme3m75dQyerxHNCzZq97Y13574R9u3rm/Uz/DtPH40v9q82R/VWRqvFu/zlsaP8pnd81dWfL0AdTNcn82Daa0r4+PZ78fjekr9SnUjrra+nMfj+3uiunva2e55fh+1tX1g8yvNa0078lu7Xy8Q5fFE59XHIX9pfD8fT097LR+0URo/6u9hv7fP2jfRepi/Vr/vF827NN/WeF5HthRXWv9afKud4To90boY6Mf1eY06SvVwHIjiYXv2UzSegfZoPlH8mnFK58uPZ36OK/Xz62K04mvt3g8szsfzeUA/P0/f3/DtPG5pfdjPlMYp1WlxpfylOjgfKM3b8P25jlY7W9uvPddXdFHmRNj6/9/HH26up9lXA11V2wa3K76j8hl76k/f3tb6G1s0bhmEHp1f+pW9NN6k1vTX/pde/nGT2ZLvv799mfbR50Wv7S/9yhm1zu8r0v1a7y/Sa3Xt/Uj7SfpK2vbr6p/EFs9n7d+8Sc9WejbSs333OjMsn3TireuFzviSvsSvrEgntmid3wnphPRspWczWi90xkvPVno2Z9M96DtlTsTRf3Ob2FGnK9wVf+JE+q2tf2KDTndYVPyG9GzPqlt/k1zS2v8T71zjU8lR+aRnIz1b6dm8R633lwnpRK+uvR9pP01IJ66g037t4OaiTO/vaIt90CdQE0/UWv8J6cR71Nr/E9IJ6dlKz0Z6ttKz2aL1/jIhnRihtZ8mpBNX0Gm/dnD3nTLpyo4lsis7Hz+9fP2WN7707prt6PzSdc12dH5p6TNrtqPzS78PzXZ0funnaraj80u/Tc12dH7p96XZjs4vLT1Sm930Rb///mKdpkTpVhvZI+2Pn/VFy89EX3Qt3jPa/2IE2kdvG51fsQXtGzES7SdxJXr36/13ytiVncmmKzyG9GG692/OxD5o/cV7RvtfCCHEHuj9RYxE+0lcid79ev+dMh+t43xrakL6MN37N2diH7T+4j2j/S+EEGIP9P4iRqL9JK5E7369+0nsEXd8SG/VQgghxHXRJ5hvG51fIYQQYjx3F2VG3PEhvVXf8uHDh+U4mj3HfMZ8hBDreKuvP1ejthZnXCf+RAh76Bm1nnF9ro7OrxiB9k2bZ63P0YyYI9bqGev1Hs6R573N90iq3ynz09/+Mh0fkn3sDpAx2uoYme9o3VrP0idQ9j3M7ruYb1549npiWF6MyePZsRd75ga1ufR+Asg5cAhxZa78+hO1R3BOf0R+tDOlNiaKqeV9NlZTqa6ovcaz9xGIxuV27wMtf8TWfhEjcpR4JO+zzy+PZ0eJqD0iyoU2+P1RoifGsyZ2D3jcEXWc8f0FjBr3kb6M5eL1KeHr5iPyo50ptTE+D469qOU+879XmN6x19SIsUrHUYwae2u/Nayt89GauH/v/182v1Pm51/+nI4/kk4XFf4+X1j4x2QTFH9GHdWbLvIU4vfSto62nkbJ3/qbMzvJeNHB8ejG6eGoMS33npTWz9P7N38G5+FcQlyNq77+oK41tfh8JW34NrSb9eNg7EcZkeMqYM38sebcbaU1bs23teat/a7Ms+bcGhN1ja6ld1x/tEBMT+wRjKjjrO8vW87PmeC6WRu+De1m/fpiHXrwuTjPSGr1nHU/HYWfV0kfhR9369h717xlL4yuqff/LxvfKXOv//kvu7AwHZON7vjYT3M9K/onBubbRa8HG6e0wdBm1h/c5jG9ZjP6PKVckc8DX8ni8Pj2kr+ExWx5kvncveN4oL3FAUoxwD8W4mw8+/XnreDXwa+Nbze2+PC45Gth54Jz8fnhnL2fCHn23kesQakNmI/zemp9a3Bd/vCUfN7isQFdavd2K77/Gc/vnrT2AePjR9Xp8+Hw+Hbvq7XDtnx47C3wGvE4RrD3vmHN+Dx2eLjdWzxugVjug8fcfgVQc6n2ms8DX2S3svd+MkxznMfn8nF4zO1b8fkAcnObJ4rnuBqlWN/GOSMft8Oyr4bFlZ7jvq2UE4+95Zg9aHynTL+2O2jsWpDdkeLvQIHGHTZRPLT34w6X13zzeKV8GC/SdofKffxt/ffjzf2h4U8UNM9nTX2z3g/bgDhsU7HeAufxuWo+D+IY7l/Luxe+tqhOxmK4VsC1I87wsd7HcUJcEex57GfWVwI1Yx4j4bXx+df6rA2w3/seBTnBmjsO18JzYH0luH4/h5LP8BaPa3kM+LfC/XV+n0O0HtxuR9Tu1zDKZ49h8bhFa6y94XFZb6E2J/YZ3uJxjVp+9Ef7XmBM1PIotTnVfJ6olqh9D7hG1lvhXD6fPYbF40fhNUNuO1rzqNX6CJzX0xqT/SPqMVo59xq3RPU7ZRKd2rCLEXYHjV0AgR8ad9jYhYpSvPnTxY+pn1l/R47PZ/1L+er1Tf+QqPo/3Y0354Uf487+dNGFtOXj+cT1letpfQKFzeCPI+AxrY4R1HKNGmMNfv19baU6sRb+aFGbE/tMI6d/LMReXPH1x+vRzxM/5oi8nG9Ezl78mj2bZ+0jz9qxt9Z8hrkefe6fNWce08/ba9S3hi19RuPnM4It+fw68Bq3OOv7y3tg9LpyvlF7s5aL28+8nzD2s+k5L75Wsz19PFhbHHuytrYSW2odMW5rv4Lmd8qw9neUJLLfsIsQrf4zrfhpAjf61W8XPEr5onifL10kSXW34vMFEyO3z+NOBDrMlyjXk3DxPZ9A2ebwx95PAmOPMS2H5ToTaz4B5DXxc7HHZ5yfEDXe0+tPDzzuo3C+ETk9ti7+GIXViZylmreM59cA+Y8E467B12tHb821flg7HG+F2pz3Yu8xj5rHSLCvcOxJa6yzvr9sAbWdtT6G1/VRON+IdbAca2o7+36KxrM2fxzJ2nF9fNSH17gF1iXKtzelOltzHEHv/18+9J0yN3eUJO7vQDE/7iwxe0vfHSSv+t6/UIy/11Z/qiO3w1+us53vVkd5Jjr7vxfwxDwrvr61tVrso/NDDn4shLjFnh84jgDPx0ef46NBTf7YG78WoPcTIfGcc/YoVz2/eI0403N2b47cX0eOdQYwxyvvJ//6/ex5XH0te8F6++MI/LnuHdPHr+nXArnOcL63rMuePPidMnwh4faOELswYRdu0kWcbG/pu4PkVVfGL8a39JzPLp6U61yfj/OYTXT2r7FmA1/hxW3Ek7K3/5axfJ8RtfZi4+DFwT8W4pms2f9HPFfw3ODjiLGPojaX1jxHrgPWtofWJ0Jr6ho1hy37wuIx5611bBnz7Jzx/NawMbB//bFl7J5+GM/YOs5ejKgFc8IcI9aOtSZ+1Jqe7fy8d0aej2fsJ6ZnPmfYf3s9p8Ez53i15/jj3ymTcBcUKvH+DpSFYvz0xn+j2+PX42/z2YUSu2AEbXj//R0uXE9Lv44/j1OvB/4tfyOJJxH7Wk+uiNIG9nl9bh6z1+dBXC+ct5QzolSTp7T+Pr9/zHmQyyziMB7wsT6OicYUYk+u9vrzDHj8Ur2PgHylua7xsX8v/Li91Gpl39Y5II+nNK6HfX7sUt+e2mr91vqA97HGgTxr4TwG8vdSq4d9W+ss1eTzPpJ7La1xec52tEBMT2yUv9Teuya+bw89Y531/aU0btSOcUtthu/Topb/CHg81NODr9nnqc2p5vMgrsVZ91ONWk2G94+Gx27RqrUG9/X9onbjkTFrlPIC9o3E52vtV/DQd8rgDhPzL7h4u1PEx/s7UBYov2mL6/4Vo0Rc76ynBSH/wqR5vNc6J4r9y5rn69enVY/pLX8j6eF2tqClPebjw7PFV4orWQ/3x7EW35f79/7NH+fAAZ/Hax/L7UI8m6u9/vjHnqg9ohS/JnfPeK183m+PcUCDXh+3M6U2phbD+XvyedCn1Jfb2YKWLmExfNTaPS1/RK3foz7g47i9F87h+/rHPUR5DG5nC1raYz4+gH/sido9pRifH4/9UaInxsOxpT6+zcf3tjPc5vuUfAzicTBnfH8BFuMP0NPORO0lfB7u05vDU+oT5VkT67EYPjxbfKW4kvWc9d8rjLX5dmhuB1F7jSgPg9w4PGvi8di3MdzPW99u8ONWDCi1RficOECpna2n1Mb4XEbv/19+mDotvX797deXX37//PLp4yS+TYddKLA7OKQP0T9+9+Xlh+9/mIR4Brb/tf7ivaL9L0bw5bcvL5+//5yVeGvo/Iot6P1FjET7SVyJ3v3a+E4Zu2AgfZwWQgghrkvvJ0Limuj8CiGEEOO5uVPGPgGZ79yY7+B4yXdwSB+j2Y7OL13XbEfnl5Y+s2Y7Or/0+9BsR+eXfq5mOzq/9NvUbEfnl35fmu3o/NLSo3X7TpmXl/8HbEP0Ax6CvqQAAAAASUVORK5CYII=

    Cheers,

    Dave

    Percent of the row total would just be the count/total count in the row * 100. I can't tell where the total count is on your matrix, if there are multiple rows with a totals row, grouped by channel, branch or however it's set up.
    In your first example, the expression for the Blue percent of row would be the blue count / total count for all the colors in the row * 100.
    =Sum(Fields!BlueCount.Value)/Sum(Fields!BlueCount.Value + Fields!OtherCount.Value + Fields!RedCount.Value + Fields!YellowCount.Value)*100

    Sue

    Hi Sue, thanks for the reply. I am after a dynamic expression something like:

    =Sum(current column group member)/Sum(all column group members)*100 

    Is this even possible?

    Cheers

    Dave

  • David Burrows

    SSC Guru

    Points: 64396

    Think you want something like this
    =(Sum(Fields!Booking_Count.Value)/ReportItems!Textbox1.Value)*100

    Replace Textbox1 with the actual name of the Total Count textbox

    Far away is close at hand in the images of elsewhere.
    Anon.

  • david_h_edmonds

    Ten Centuries

    Points: 1232

    David Burrows - Friday, March 29, 2019 7:15 AM

    Think you want something like this
    =(Fields!Booking_Count.Value/ReportItems!Textbox1.Value)*100

    Replace Textbox1 with the actual name of the Total Count textbox

    Ok this could work but there is 1 more complication, there is a total for each row of the matrix so I would need a total for each member of the row group and then lookup up the correct total based on the row group member.

    Revising what I put earlier, that alters to:

    =Sum(current column group member and row group member)/Sum(all column group members for current row group member)*100
    How could I achieve this?
    Or am I missing the point? I am honestly so confused by this, Excel does it in 2 clicks and this seems so complicated.

    Many thanks,
    Dave

  • David Burrows

    SSC Guru

    Points: 64396

    Sorry missed the Sum

    =(Sum(Fields!Booking_Count.Value)/ReportItems!Textbox1.Value)*100

    *Edited my original post as well

    Far away is close at hand in the images of elsewhere.
    Anon.

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply