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: compa...
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

pxg08680's avatar
pxg08680
Resolver III
8 years ago

Abduvali

Filter works.

Gelaincan mark this as solution if this is what you were trying to do.

Gelain's avatar
Gelain
Frequent Visitor
8 years ago

 

Hello pxg08680 and Abduvali!

 

Thank you for helping me.

 

I was able to correctly generate the value sent and received by company. To finish, I need to create two filters: one for the company that transferred and another filter for the company that received the values, that is, to detail the destination of the resources transferred by company. I made a few attempts, but could not solve.

 

  • Abduvali's avatar
    Abduvali
    Skilled Sharer
    8 years ago

    Gelain,

     

    Try this...