Forum Discussion

hanyfouda2023's avatar
hanyfouda2023
Helper II
3 years ago

Avg Monthly usage

Dear Helpers, I have data as following:-

Sales table including sold qty  & amount & articles code 

I need to know how to calculate average sales for each item 

For example item number"123" how many pieces sold in 2023 

Then add month to check the average mothly usage for each item

Thanks

 

Need Help

1 Reply

  • v-zhangti's avatar
    v-zhangti
    Community Support
    3 years ago

    Hi, hanyfouda2023 

     

    Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures or Excel. I look forward to your response.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.