2 Replies Latest reply: Jan 26, 2015 11:33 AM by Андрей Шепель RSS

    Calculating data by selected items in listbox

    Андрей Шепель

      Good day!

      I have listbox with BrandName, Shops and Sales by them.

      Tell me please, is in QV any way to calculate the following expression?

       

      1. Sum of sales for that rows, which are connected only with selected brands

      2. Sum of sales for that rows, which are connected with all selected brands.

       

      For example: I select three brands in list box;

      I want to calculate:

      1. Sum of sales for only those shops, which bought only first brand

      2. Sum of sales for only those shops, which bought only second brand

      3. Sum of sales for only those shops, which bought only third brand

      4. Sum of sales for only those shops, which bought at least 1 item of first, second and third brand

       

      Examples in attached files.

       

       

      Thanks.