8 Replies Latest reply on Oct 2, 2018 10:07 AM by Hari Ankem

    KPI Based on Other Attributes

    Chike Ckuks

      Hello Guys, am looking to create an additional column based on a sub-section of a dimension. I have a dimension called Country which has some subs under it. COUNTRY ---> ALL, USD, YEN, POUNDS, EUR. Am looking to create an additional column which is All-(Sum(USD:EUR:GBP:FRN:YEN) = 0. Please, see below a screen shot of what am trying to attain which is the highlighted green column. Please, I would appreciate any input to this. Thanks very much