1 of 1 people found this helpful
Create a Calc:
Turn it to Discrete. Drag to Rows as First PIll and Now your entire data will be disaggegated and you can copy to crosstab
Thanks a lot! Is there any way to hide the counting column that displays for the calculation?
Yes.. right click on that pill and untick show header. If it helps please close the Thread by marking my answer as CORRECT to help others.