Last answered:

23 Aug 2023

Posted on:

22 Aug 2023

0

Resolved: problem with unpivoted columns

when i untick null values from sales amount then the value (36) contain in currency key is automaticaly removed 

how i can fix this because currency key (36) is only relate to nulls of sales amount 

1 answers ( 1 marked as helpful)
Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
Posted on:

23 Aug 2023

0

You can replace nulls with 0 so they will not be removed automatically after unpivot.

Submit an answer