Forum Discussion

Amerivike's avatar
Amerivike
Advocate II
5 years ago

Filtering Denominator Based on Data From Another Column

  I have a dataset that looks like this:   State Ship Date Account Category Product Ship Volume TX 1/4/2020 Account 1 Category A Product 6        5 TX 1/4/2020 Account 1 Cate...
v-easonf-msft's avatar
v-easonf-msft
Community Support
5 years ago

Hi, Amerivike 

Sorry,I'm still confused about your question. Can you explain it in more detail ?

How to calculate  all of the Category A volume that would have been received on or after the initial shipment of product 6.

Why the value corresponding to "Account 3" is 86.

 

Best Regards,
Community Support Team _ Eason

Amerivike's avatar
Amerivike
Advocate II
5 years ago

 

Thanks for the response, but this was moved to another group and apparently there was a resolution.

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    5 years ago

    Hi, Amerivike 

    If you have worked it out ,can you accept your reply as  a solution to close this thread?

    Thanks.

     

    Best Regards,
    Community Support Team _ Eason