Hi All,
Attaching an example excel data and the table. I need the data to be converted to the format of the table can some one please help I tired one by with all the values I have to built several workflows for each LOB.
Regards
Rohini
Solved! Go to Solution.
Hi @rohini
I have built a workflow to replicate what you are after:
I created a new field with was the month number and month name, this helps order the fields in the Cross tab to be chronological.
Let me know if you have any questions.
thank you.
This will work. One more small doubt. will I be able to get for eg. 2018 car value and the 2019 car value below each other
Sure, you'll just want to add a sort tool after the crosstab tool.
Set it up as above and that will put it in order