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

According to your solution I see some extra data. Looking at this below image

Table1 is raw data. By applying your formula and making the data into a table,

The yellow marked Row seems to be an extra one becuase, take an example with ID Company 3::

 

ID Compnay 3 has

Receive 1000 which is row #4 GOOD.

Transfer of 1000 and 500 which are row #4 and row #6 GOOD.

But I don't understand the Row#5 which says Receive 1000 and transfer 1000 NOT GOOD. 

 

Abduvali's avatar
Abduvali
Skilled Sharer
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...