3 Replies Latest reply on Mar 26, 2020 9:46 AM by Deepak Rai

Calculated : Auto suggestion

Hi all,

I tried searching the internet though no luck in finding a solution for this problem. Where, I need to get to sum the order qty based on the max qty, and redistribute the remaining qty to the remaining order no's. Is this mathematically feasible in Tableau? and I have attached the .twbx also here.

Thank you

Mike

• 1. Re: Calculated : Auto suggestion

Good morning

Help me better understand the goal

I get why the first set is 99 but not the values circled in black and in red - what is the logic

Thanks

Jim

• 2. Re: Calculated : Auto suggestion

Hi Jim,

Column E will be a calculated field which will determine the number of qty based on Max Qty (Column D)

For instance, on what in circled in black, two orders for product B both have an order qty of 20 however the max qty per order is 30, so the remaining 10 qty's.

For on what in circled in red, three order for Product C has 100, 80, 20 however the max qty per order is 180, qty of order 2 will be added to order 1 as it meets the max qty, no changes for order 3 (order qty 20).

I hope my explanation is clear.

Thank you

Mike

• 3. Re: Calculated : Auto suggestion

Here it is:

Thanks

Deepak

If it Helps, pL mark it  Helpful and CORRECT to Close Thread