Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Remove Default Sorting of Cross tab
Saggy123
hi,
I want to remove default sorting of cross tab because i not getting desired out put.
please any one can help me?
thanks in advance!
Find more posts tagged with
Comments
kclark
If you click on the crosstab then you can add sorting in property editor > Sorting. What kind of output are you wanting in the crosstab?
Saggy123
thank you for reply.
I don`t want any external sorting in cross tab because i have done sorting in my sql query.
but then also cross tab give me default sorted data?
kclark
The default sorting on a crosstab can't be removed. If you wanted to keep the crosstab in the same order as the dataset you could add a running count computed column then sort the crosstab by that value.
Saggy123
thanks Kclark ,
it worked for me and i getting desired output.
thanks again for providing solution .