1 Reply Latest reply on Aug 14, 2016 8:38 AM by Yuriy Fal

    Table Calculation across cells from different rows & columns

    Chandra Shetty

      I have a use case where I want to get the difference b/w each of the cells of a cross table & a fixed cell (highlighted).

       

       

      Columns under "Axis0" (B-G) are the data from a cube, while "Calculated Axis0" are my expected result.

      So Cells will be computed as below

      H3= B3-G3 -> 20,000 - 1000 = 19,000

      H4= B4-G3 ->  5,000 - 1000 = 4,000

      I3= C3-G3 -> 30,000 - 1000 = 29,000

      I4= C4-G3 -> 15,000 - 1000 = 14,000

       

      I have attached the data & formulas in the spreadsheet here.

      All help is highly appreciated.

       

      Thanks!