2 Replies Latest reply: Feb 26, 2015 2:35 PM by Jhansi Jangam RSS

    Calculated Dimension in Barchart

      Hi Guys,

      I want to create a chart with two dimensions(Report Month, Category) , Category contains one calculated Value (NICO)
      Now Dimensions are : Report Month
                           Category_Name(Dispute, Legal Dispute, Collectible, NICO --> Calculated value in Script as below)


      For the calculated dimension i created a dummy Dimension at backend by using Inline function

      Load *Inline[
      CategoryName, Category
      Dispute, Dispute
      Legal Dispute, Legal Dispute
      Collectible, Collectible
      , NICO
      ];

      So by this i can able to get the NICO in Category. But the problem arises while assigning a value for NICO.

      Expression used :
      =if(Category='NICO',sum({<CompanyID={'C0,'c1','C2'}>}Amount),sum(Amount))