12 Replies Latest reply on Mar 18, 2016 6:40 AM by Hemalatha B

    How do i use a if statement with aggregated column and dimension not in View

    Hemalatha B

      So i have data in below format. Median Sales Price is a calculated column which is a median value of sales price per part number.

      I need to get for each part number how many quotes have a quote price greater than median sales price and then display the sum of quantity for the same.

       

       

      Part Number

      Quote_Id
      Quote_Price_per_item
      Median Sales Price
       
      Quantity
      PART001
      Q1001
      6021.420
      Q10022021.410
      Q10039021.470
      Q10044021.412
      Q10051021.45
      PART002Q200112060500
      Q20025060380
      Q200310060430

                                                                                                                                                

      Part NumberQuote_IdQuote_Price_per_itemMedian Sales PriceQuantity
      PART001Q1001604020
      Q1002384010
      Q1003904070
      Q1004404012
      Q1005504015
      Q1006604020
      Q1007704040
      PART002Q2001120105500
      Q200290105300
      Q2003150105800
      Q2004110105450
      Q2005120105500
      Q2006130105650

       

      Desired Output:

       

      Part NumberNo of Quotes
      Total Quantity
      PART0013112
      PART0022930

       

      Kindly help in understanding which calculations would help achieve the desired output.