4 Replies Latest reply: Sep 3, 2018 4:30 PM by omar bensalem RSS

    Total Percentage in table with dim Limitation

    Motty Gal

      Hello Experts.

       

      I'm facing an issue(see attached jpeg):

      I've created a straight table with on dimension

      The table has the following Columns: C, A(Simple sum), B(simple Sum) and  A/B which shows the ration between A and B,

      Now, I wanted to show the top 10 of column C so I used the Dim limitation and set it on fix 10.

      After doing so,  the Total Remained the same(meaning calculating sum for all the products). Changing the Total setting per column from auto to sum fixed the problem except for the percentage. I cant use it on column A/B because it shows a simple Total of percentage and not the percentage of the Total row.

      In the example attached, the Total Setting in column A/B is  Auto and show 94.6%. The Sum I need Is 57.4%

       

      Regards,

      Motty