Guys is it possible to create column (or more than one depending on some values).
For example if i would like to read data from selected range of dates (four weeks)
in table i would like to have four columns one for each week.
I for example I'll select wider range of dates, for example 8 weeks, it will generate 8 columns, one for each week etc.
Is it possible ?
I so, how to do it ?
For example:
start_date 2015-12-01 end_date 2015-12-31 (4 weeks +)
i need 4 columns + sum(TOTAL)
Product | Week 1 | Week 2 | Week 3 | Week 4 | TOTAL |
Monitor | 1 | 4 | 1 | 8 | 14 |
Keyboard | 20 | 35 | 13 | 2 | 70 |
if for example I'll select more like 8 weeks period... i would like to have product + column for each week (8) + total.
Product | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week ... | TOTAL |
Product 1 | 1 | 1 | 1 | 1 | 1 | 1 | 11 | 11 | 28 |
Product 2 | 12 | 1 | 14 | 2 | 16 | 4 | 0 | 0 | 49 |
Is it possible in Odoo ? (using for example PHP I can do it easily, unfortunately I can't use my favorite language in this case :) )