Need to run a loop for each row of the table

[dhanopiyaankit]

Hi All,
I need to do a calculation “Count of Months to utilize Stock” in a table in Quicksight. “Count of Months to utilize Stock” is the months taken to utilize all the stock available for each month as shown in the Result Table.
Explanation of the data in “Result table”:

Date : Date aggregated on month level
Stock: Stock or inventory available in the given month
Sales Forecast: Forecast of the sales for each month. This field will be used to identify the “Count of Months to utilize Stock”
“Count of Months to utilize Stock”: It is the months taken to utilize all the stock available for each month.
For Example: “Count of Months to utilize Stock” for Jan month: (30000-(123137+105118+69543)) in this cal stock will be finished in 3 months so “Count of Months to utilize Stock” is 3
Feb month: 128 - (105118+69543) in this cal stock will be finished in 3 months so “Count of Months to utilize Stock” is 3

I am attaching an excel that contain the Result table and a table to show how to calculate the “Count of Months to utilize Stock”. Please take a look and let me know if you need more information.
Thanks in advance!

[sagmukhe]

Hello @dhanopiyaankit - I have tried to respond to the other thread that you raised. Please see my post link below for your reference.

Need to run a loop for each row of table

@dhanopiyaankit - This is an interesting problem and I don’t have any good optimized solution for you at the moment in case you would like to do it natively in QuickSight. However, since I loved your problem statement, wanted to share an potential crude implementation to you which I was playing around with. [image] See the Above Snapshot and Months to Server is the final metric I believe what you are looking for. Sharing some of the calculations below for your reference as well. Jan Sales : …

Would request you close this post by marking it as Solution to remove unnecessary duplication of threads. Thank you for understanding!