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)
You can replace nulls with 0 so they will not be removed automatically after unpivot.