Forum Discussion

IF's avatar
IF
Post Prodigy
6 years ago

Exception for sub-total

Hi, I want to re-do a table that was done in excel. I have the following data: XX YY A B C D E F G I J M P R PP RR 35353 2M 236 23 4 6 7 5 5 4 6 9 22 11 9% 5% ...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

IF , not very clear

But it would be like

New B = Sum(Table[B])- Sum(Table[M])

% = Divide([New B], Sum(Table[B])) , what is denominator for % ?

  • IF's avatar
    IF
    Post Prodigy
    6 years ago

    Hi,

    Thanks for the answer. Sorry for being unclear. Based on the data, I want to have the following table:

      ABCPPRR
    353532M2362349%5%
    353533M2332126%4%
    353536M2513349%4%
    353537M2634326%3%
       34 3% 
    Total(N) 983861226%16%
    Total(%)  8.7%1.2%  

     

    8.7% is 86/983  (SUM(B)-SUM(M))/SUM(A) However, I don't know how to show it in a table or in a similar format that I provided. This should be series for all XX values. Actually a matrix or a table is fine as well. Also as you see in Total(N), some of the totals are exclusion of SUM(M) and some of them don't include. When I have a table or matrix, it gives total with the same logic for all columns, I belive. At least, I don't know.

    All the best