Forum Discussion

fusiee_'s avatar
fusiee_
Regular Visitor
3 years ago

Multiple values in rows and columns calculate based on each categorical values

Hi Everyone,    I have a fairly complicated task where I need help. I have a task where I have a data about each product data and and how long each department took to complete their task and then c...
Need Help
v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi, fusiee_ 

Can you share the expected result in excel to further clarify your needs?

Best Regards,
Community Support Team _ Eason

  • fusiee_'s avatar
    fusiee_
    Regular Visitor
    3 years ago

    The expected result would be like following: 

     

    Sales ( All the sales days summed For commercial data tasks) : 46

    Sales ( All the sales summed for Technical Data Tasks: 10 

    Total Sales = 56

     

    Same structrue will be for all the departments based.. so we can evaluate how departments doing when compared with other departments under Commercial or Technical Data tasks. 

     

    Looking Forward to hearing from you.

     

    Best,