Forum Discussion

abc_777's avatar
abc_777
Solution Specialist
3 years ago

hi

Hi,

 

I have attached sample file  with 3 sheets

 

Sheet 2- Cross Sale 2

 

1) In cross sale  i have calculation for with both product purchased but when i want to see quantity wise for 2 products purchased            its only show me  product_file table item_name wise quantity not together with filter_product table item_name quantity along           with product_file table item_name wise quantity

 

         with 2 products purchased i want to see quantity of two different product together

         i.e. whole chicken curry cut - 2 kilo and with whole chicken curry customer bought 3 kilo premium curry beef

         so in matrix i want to see whole chicken curry cut and premium curry beef = 5 kilo together

 

2) and then i want to see that 5 kilo also in percentage. what percentage of quantity customer bought two products

 

3) Now as i can see product_file table item_name wise quantity i also want to see filter_product table item_name quantity 

 

 

want to see quantity of two products in matrix format. following quantity is not correct

 

 

4)  bring that customer with both product quantity percentage into matrix like follows

 

thanks

 

 

Need Help

6 Replies

  • abc_777's avatar
    abc_777
    Solution Specialist
    3 years ago

    Hi,

     

    i have given sample file. please help me our from this 

     

    thanks

    • abc_777's avatar
      abc_777
      Solution Specialist
      3 years ago

      hello, i tried many ways but failed

       

      i got quantity by filtering one table same way i want quantity from other table

       

      coz in visualization i see quantity for from one item table which is not correct for cross sale or customer who bought 2 products

       

      so i need quantity from other table and add them both then i got correct ans.

       

      please share if i am wrong

       

      thanks

      • abc_777's avatar
        abc_777
        Solution Specialist
        3 years ago

        hello

         

        no one have the solution for this issue?

         

        thx

  • abc_777's avatar
    abc_777
    Solution Specialist
    3 years ago

    hi,

     

    can some one please help me to find the quantity for filtered_product table item_name. 

     

    i really need that so i can add that quantity with product_file table item_name quantity and then can do percentage os both table selected item_name quantity.

     

    Please help with my sample file