Forum Discussion

Gelain's avatar
Gelain
Frequent Visitor
8 years ago
Solved

Filter values ​​by company

Hello!

 

I'm having trouble solving the following problem: I need to create a filter and graph to demonstrate how much each company has transferred and received from each other. For example: company 1 transferred to the company 2 US $ 4,000.00 and received the 3 US $ 500.00.

 

Thank you.

 

Need Help
  • Abduvali's avatar
    Abduvali
    8 years ago

    pxg08680

    Gelain

     

    My bad =oP applying Filter will solve the issue:

    • Received = CALCULATE(SUM(Sheet6[Sales]),FILTER(Sheet6,Sheet6[Extract] = "Received"))
    • Transferred = CALCULATE(SUM(Sheet6[Sales]),FILTER(Sheet6,Sheet6[Extract] = "Transferred"))

     

    Regards

    Abduvali