I have three sum columns and an order by column sequenced as 1,2,3 and so on after doing pivot i want my rows to be arranged as per order by using sort but without displaying order by column.
Is there any way to hide order by column.
FYI while doing pivot i have included order by using sum function without sum enabled.