8 Replies Latest reply: May 17, 2014 3:47 AM by Tresesco B RSS

    Set analysis Expression for a single item

    Ruchi Bagaria

      In a pivot table having item codes, and sum of item cost (with some calculations and conditions), I want to have separate calculation for just one item. How do I do that in the fronted using set analysis?

       

      Eg.

       

      Header 1Header 2
      100014567
      10002232131
      1000332233
      10004
      100053486

       

      Here I want 10004 to be calculated as  10002/10001 (Division) i.e. (232131/4567). How do I do?

      TIA