9 Replies Latest reply: Jul 16, 2014 9:19 AM by Paramita Sahu RSS

    Conditional calculation NOT based on dimension in a table

    Paramita Sahu

      Hi All

       

      I have a requirement to do a particular calculation as follows :

       

      Source data looks like --

       

      Catalog#NTACustomerPrice
      ABC123Ax12.32
      ABC123Ax2.4
      ABC123Ay6.5
      ABC123By8.6
      ABC123Bz9.2
      ABC123Bz8.9

       

      I have selections on Catalog# and NTA. I have a button to Show/Hide Customer from the table.

       

      I have to display min Price based on Catalog#, NTA and Customer against Catalog#

      So the output I should get

      ABC123           $2.4

      irrespective of the 'Show/Hide' Customers.

       

      Please advise. Attached is the sample file.