05/01/2022
100
300
04/01/2022
200
400
Text
DateTimeParse([_CurrentField_],"%d-%m-%Y")
Parsing of date
DateTimeParse([_CurrentField_],"%d-%m-%Y")
Date - Croissant
Date
SalesPM
Int32
4
Empty
iif(isnull([Row-1:SalesPM]),[Row-1:Sales],null())
Sales PM Field
iif(isnull([Row-1:SalesPM]),[Row-1:Sales],null())
Date
ProfitPM
Int32
4
Empty
iif(isnull([Row-1:ProfitPM]),[Row-1:Profit],null())
Sales PM Field
iif(isnull([Row-1:ProfitPM]),[Row-1:Profit],null())
Order of desired output
Date - Décroissant
Order columns
Order columns
Horizontal
Sales and profit