I have a Rowid column in my QVD , it is the sorting for my entire table. While adding the Rowid column in pivot table the sorting working fine, when I am hiding the column losing the sorting and also I have tried sorting expression option but sorting not working properly ,only the sorting is working when adding the column into a table ,but Rowid column is not required to show in my current pivot table. How to hide it ,any help..
