1 Reply Latest reply: Aug 6, 2018 4:29 PM by Sunny Talwar RSS

    Set analysis in Combo Charts

    Mallika Mhapankar

      I want to make a combo chart of Primary axis-'NetSalesUSD' as bars and secondary axis-average of the 'Discount%' as markers only for the entries "LRM" in the field 'LRM-MVS' across Regions(Dimension).

       

      The set analysis function I used in the expression for measure is as follows:

       

      =If([LRM-MVS]='LRM' ,[Discount%])

      However, this is not functioning and does not take into acount that I need average od the discount %. Could someone help me with this code?