Chart inventory range stock supply

[Anonymous]

Hi community

Was looking for a solution to display the range in months of our stocks.

Lets say i have an item with 50units  and a monthly av. consumption of 10 units. i would like to aggregate the value of the stock, to month or quarter dimension on display this in bar chart.

I did check for a solution and found something, but the result is not what i want. In this sample the bar chart dimensions are 3M, 6M, 9M, 12M, 18M and over 18 months range. That’s actually ok from the dimension side. But the aggregation is not what i need. This solution will calculate the stock range in months (current inventory/avg. consumption) and add all the stock value to the same dimension value, in this case 6M. The result which i would like to have, is that the value of 30units will be added to 3M and the value of 20units to 6M. Even better it would be if i could use the calendar dimmension month-year, to display the values.

I made a test qvd, for better understanding.

Would be great if somebody could help me

Many thansk