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)
Work Around on Sorting Crosstab by Grand Total Value
yus2aces
<p>I have a crosstab table (please see attached picture). This tabel was grouped by District, Estate, Rayon & Fullname. I have succesfully sort the table by Grand Total, when only show the Fullname column. But how to sort this with the same result but still showing the District, Estate and Rayon column?</p>
Find more posts tagged with
Comments
yus2aces
<p>Already find the way to do this. I am changing the grouping level in data cube. I am switching the group level the other way around. First level is Fullname, then Rayon, and Estate and the last one (lowest level) is District. It shows the right sorting like what I want to have.</p><p>Thank you.</p>