Notifications
Clear all
Topic starter
Source data
| rundate | entity | leaf_level_id | record_type | Amount |
| 31/03/2020 | J11 | L2_DEDASS | CA | -11 |
| 30/09/2019 | J11 | L2_DEDASS | CA | -9 |
Expected Result set
| entity | leaf_level_id | record_type | 31/03/2020 | 30/09/2019 |
| J11 | L2_DEDASS | CA | -11 | -9 |
Posted : 05/03/2021 4:13 am
It looks like you just need to pivot on the RunDate column using Amount as the Value field.
Posted : 05/03/2021 5:33 am