I want to use sales and stock value at the begining of the month in the same chart, but when I make sum by monthly sales, for stock, I don't need sum of month, but I need to see the value of the last selected month. Sales, stock aare in the same field.
ian.15 | feb.15 | mar.15 | apr.15 | mai.15 | Total |
Sales | 10 | 3 | 10 | 5 | 20 | 48 | sum |
Profit | 2 | 2 | 2 | 2 | 2 | 10 | sum |
Stock (start month) | 20 | 30 | 23 | 34 | 34 | 34 | last value of selceted month/year |
Thanks