Forum Discussion
Dmitriy
7 years agoFrequent Visitor
Text value in matrix (several text values for column group)
I have table with information about project which I need to show by Month. Initial Data looks like: | Company | Project | ProjectInfo | Month | Year |
|-------------|--...
- 7 years ago
Dmitriy
7 years agoFrequent Visitor
DUBPLICATE (my previous question marked as spam)
I have table with information about project which I need to show by Month.
Initial Data looks like:
| Company | Project | ProjectInfo | Month | Year | |-------------|--------------|-------------|----------------|--------------| | Company1 | Project1 | text1 | september | 2018 | | Company1 | Project1 | text2 | october | 2018 | | Company1 | Project1 | text3 | november | 2018 | | Company1 | Project1 | text4 | november | 2018 | | Company2 | Project2 | text5 | september | 2018 | | Company3 | Project3 | text6 | october | 2018 |
When I need to use text data in value of matrix, Matrix can take only 1 value for each month (first or last), but I need information of all.
Example of expected data in matrix:
| september | october | october | Company1 |-------------|----------------|--------------| Project1 | text1 | text2 | text3 | | | | text4 |
If it doesn't possible, then duplicate new row with this project on case when I table has several ProjectInfo data in 1 month.
| september | october | october | Company1 |-------------|----------------|--------------| Project1 | text1 | text2 | text3 | Project1 | | | text4 |
How I it can be done ?
Ashish_Mathur
Super User
7 years ago