Pivot table
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Datasets
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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