Hi all,
I have a table with users activity data as following:
| Date (D-M-YY) | User | Resource | Elapsed Time |
1-1-19 | User 1 | Resource 1 | 1 |
| 1-2-19 | user 2 | Resource 1 | 2 |
| 1-1-19 | User 3 | Resource 2 | 2 |
| 1-2-19 | User 4 | Resource 2 | 1 |
I want to build a pivot table as the following and ADD A TREND INDICATOR ARROW (If trend is up=red up arrow / If trend is down=green down arrow)
| Resource | January (Average Elapsed T) | February (Average Elapsed T) | Trend arrow |
| Resource 1 | 1 | 2 | UP RED ARROW |
| Resource 2 | 2 | 1 | DOWN GREEN ARROW |
How can I build this??? I NEED A FORMULA OR SOMETHING THAT ANALYSE THE TREND (I will have many resources and I want to have the monthly average elapsed time and the arrow should take into account the months showed in the table and indicate the trend)
Thank you all
