Forum Discussion
Solved
how to create data type with some missing data
hi,
Please see below table. Could you help me, please?
| I have | I have | I have | I have | I want to have | I want to have | |
| region | atrybut | year | month | I want - data type | I want also | |
| CM | sales 1 | 2021 | 2021 | 2021 | ||
| CM | sales 1 | 2022 | 2022 | 2022 | ||
| CM | sales 1 | January | January 2023 | |||
| CM | sales 1 | February | February 2023 | |||
| CM | sales 1 | March | March 2023 | |||
| CM | sales 1 | April | April 2023 | |||
| CM | sales 1 | May | May 2023 | |||
| CM | sales 1 | June | June 2023 | |||
| CM | sales 1 | July | July 2023 | |||
| CM | sales 1 | August | August 2023 | |||
| CM | sales 1 | September | September 2023 | |||
| CM | sales 1 | October | October 2023 | |||
| CM | sales 1 | November | November 2023 | |||
| CM | sales 1 | December | December 2023 | 2023 | ||
| CM | sales 2 | January | January 2024 | |||
| CM | sales 2 | February | February 2024 | |||
| CM | sales 2 | March | March 2024 | Q1 2024 | ||
| CM | sales 2 | April | April 2024 | |||
| CM | sales 2 | May | May 2024 | |||
| CM | sales 2 | June | June 2024 | Q2 2024 | ||
| CM | sales 2 | July | July 2024 | |||
| CM | sales 2 | August | August 2024 | |||
| CM | sales 2 | September | September 2024 | Q3 2024 | ||
| next months | ||||||
| PN | sales 1 | 2021 | ||||
| PN | sales 1 | 2022 | ||||
| PN | sales 1 | January | January 2023 | |||
| PN | sales 1 | February | February 2023 | |||
| PN | sales 1 | March | March 2023 | |||
| PN | sales 1 | April | April 2023 | |||
| PN | sales 1 | May | May 2023 | |||
| PN | sales 1 | June | June 2023 | |||
| PN | sales 1 | July | July 2023 | |||
| PN | sales 1 | August | August 2023 | |||
| PN | sales 1 | September | September 2023 | |||
| PN | sales 1 | October | October 2023 | |||
| PN | sales 1 | November | November 2023 | |||
| PN | sales 2 | December | December 2023 | 2023 | ||
| PN | sales 2 | January | January 2024 | |||
| PN | sales 2 | February | February 2024 | |||
| PN | sales 2 | March | March 2024 | Q1 2024 | ||
| PN | sales 2 | April | April 2024 | |||
| PN | sales 2 | May | May 2024 | |||
| PN | sales 2 | June | June 2024 | Q2 2024 | ||
| PN | sales 2 | July | July 2024 | |||
| PN | sales 2 | August | August 2024 | |||
| PN | sales 2 | September | September 2024 | Q3 2024 | ||
| next months |
thank you in advance
2 Replies
Hi Ewa_28
The problem and what you want is not clear.
Please try stating again the problem and explain with a clear example what your desired result is.
Regards
Phil
