7 Replies Latest reply on Oct 24, 2016 9:05 AM by Adil Al Raeesi

    table calculation to add measures

    Adil Al Raeesi

      Hi Everyone,

       

      This should be really easy, but for the life of me I am not able to figure it out! I've spent hours trolling through the internet researching (trying to understand) the concept of table calculations and have finally decided that it is beyond me!

       

      So here's what I am trying to add. I have a very simple table as below:

       

       

      I have a table with four dimensions - Year and Measure names in columns and Function Name and service code in rows.

       

      The measures are arranged in a columnar fashion.

       

      What I am trying to do is sum the three red measure values above [Direct oh..], [Div Ohead] and [Regional], returing the sum for each row in the column next to it.

       

      I've tried window_sum but it doesn't seem to be doing the trick.

       

      Would appreciate it if someone could help me figure this out.

       

      Thanks