Data wants in different column Reporting Month Wise

[Rhaldhar]

Hi All,

Could you please help me to get the in last column (Amount) the data coming from green column. so, If I am sitting in May then May data wants in to last column, if in June then June data want in last column. so how I can get the data like this way. Please help me to build workflow for same.

Thanks,

Rajeev

[OTrieger]

@Rhaldhar 
One way you will need to Transpose the data so you will have the dates as a column, then get the month from the data and create a flag that check which month it is and then join the data with ItemID and you have the total.

[OTrieger]

The above is a guidance, the general steps on how to get the data there, work it out form your hand what is exactly needed to be done.
You know that you need to transpose the data to get the dates to so you can check which month it is, this is the tip here, the ball is in your hands now.

[Raj]

@Rhaldhar 
find the workflow attached

mark done if solved.

[TUSHAR050392]

Hey @Rhaldhar Another approach -

If your data is going to have columns for all 12 months then you can simply go for a formula tool using IF Else statement creating a new column - Amount.

IF DatetimeMonth(Datetimetoday()) = 1 THEN [1/31/2024] ELSEIF 

DatetimeMonth(Datetimetoday()) = 2 THEN [2/29/2024] ELSEIF ...... 

Continue till December

Hope this helps