This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Facing issues in creating some pivot view. I tried with summarize activity but unable to make logic and create this view. Values as shown blow.
Expected result would be - also if there are 3 mode in particular Mode column I need to maintain Mode sequence as A, B, C
Could you guys help me. Thanks in advance.
Go to Solution.
Go to Solution.
To get this kind of output we need to use multi-row formula tool and convert below rows to blanks.
1. Using sort tool to sort by code and then mode to bring it in order.
2. In multi-row formula tool using groupby to keep only 1st row and convert all to blank.
3. Using select tool to rename and keep only required columns.
Hope this helps : )
Thanks for replying again. but sorry I changed the mode.. the correct Mode was P, S, C. so there is no ascending format.so how can I set the sequence let me know. Expected result would be.
It needs to sorted by ascending or descending for the rows to be grouped together. Or else it wont be displayed properly.
so you are saying there is no another way, activity, and logic to set this particular sequence P,S,C. I need this sequence because later I need to apply Xlookup
If you have a predefined sequence we can definitely sort on that to maintain desired order.
You can do something like this to maintain the desired sequence.
Thanks it worked. 😊
Happy to help : ) @AS