Hi all,
I have following table:
| Customer | Month | Value |
| A | 31.12.2017 | 500 |
| A | 31.01.2018 | 505 |
| A | 28.02.2018 | 510 |
| A | 31.03.2018 | 520 |
| B | 28.02.2018 | 200 |
| B | 31.03.2018 | 205 |
| C | 31.12.2017 | 300 |
| C | 31.01.2018 | 300 |
| C | 28.02.2018 | 300 |
I need a Pivot Table by month were it should Show a value if the month before or after is missing (or 0). But I dont a growth number if there is a value at the month before and after. The result should be (Start Date is the 31.01.2018 - The date 31.12.2017 is only displayed to see if there is a value in the month before or not):
Do you have any idea?
| Month | | |
| Customer | 31.01.2018 | 28.02.2018 | 31.03.2018 |
| A | 0 | 0 | 0 |
| B | 0 | 200 | 0 |
| C | 0 | 0 | -300 |
