1 Reply Latest reply on Sep 18, 2014 7:47 AM by Dave Holmes-Kinsella

    Create Column-wiz % of Totals  and Row-wise differences between them

    Dave Holmes-Kinsella

      My goal is to have a four column report, as shown below, where it shows how each merchant (M1, M2, M3) has changed in behavior over time.


      Example report in Excel: http://www.screencast.com/t/ShfeE3Gbyty


      Note that the denominator for each period has changed and so the the Market Share difference is calculated as a simple difference between values.


      Now it's my understanding that you can't calculate % values using a Table Calculation and then refer to those in other calculations, so I have been taking the approach of using window_sum() to calculate the %s myself.


      But, it resolutely refuses to calculate properly. In my example, attached, I'm trying to get baseTotal to be 68 and compTotal to be 71, so that I can calculate the % of values  appropriately.


      However, my waning powers of deduction and inference are unequal to the task.


      Ultimately I want the "% Change" Column to show the values as indicated in the screenshot (and Excel spreadsheet)