2 Replies Latest reply on May 25, 2012 7:06 PM by Kurt Slater

    Foiled by a seemingly simple calculation

    Kurt Slater

      Hi all.  I'm stumped by what seems like a very simple calculation but I can't figure it out.

       

      As a simple example, I've got a data set that is simply date, category, subcategory and amount and my output is the table below. The % of Total should be the % of the daily total so that the first four rows in the table will add to 100%. I think I've tried every combination of "compute using" but none seem to do what I'm wanting.  I suspect I'm just missing something simple. A twbx file is attached.

       

      Thanks,

      Kurt

       

      5-25-2012 1-33-41 PM.gif