2 Replies Latest reply on Sep 6, 2018 10:07 AM by Michael Ye

    Grouping the Product IDs as available or unavailable based on the availability flag.

    Jayeeta Biswas

      I have these 4 columns:  Country, Product ID, PriceList Name and Availability.

      Picture.JPG

      In a specific country there are specific Price List names(One or more than one. Varies from Country to Country). So the Product IDs whose availability flag is "Y", even for one of the Price List Name, then it's  considered as "Available". It will be considered as "Unavailable" only if the availability is "N" for all the price list Name. I'm not sure how to  do the calculation part to achieve this result. Please help me with the solution.