Hello SME,
I'm trying to change the layout of the Data tab into the Report tab without using the Report tool. What's the best approach to do this? I suppose that I could do it the long way but I'm trying to figure out the best approach.
Thank you,
kwl
Solved! Go to Solution.
@knnwndlm
If I understand your intention correctly, it is a typical use of "Cross Tab".
Thank you! That's what I got wrong in one of the fields. That's why I couldn't get it to work.
@knnwndlm
We can use a Tile tool to get the original order and bring into the result as below.