Joined: 11 Aug 2010
Online Status: Offline
Posts: 7
Topic: Group Sort on Formula field value Posted: 22 Aug 2010 at 7:12am
Hi,
I have a summary report that shows State (GF1), Store, Orders, Returns & %Returns (all in GF2). Orders is a DistinctCount of an Excel field, Returns is a formula based Running Total, %Returns is a formula.
Report works fine, but I now want to sort on %Returns. GroupSortExpert only gives me the option to sort by Orders.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 23 Aug 2010 at 3:31am
for sorting the field has to either be a summary that cab ne created via Insert Summary function or it has to be summarized outside of crystal and broght in as part of the data set
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
