Sequencing rows in a trailer group

Resolved Sequencing rows in a trailer group

How-to

Votes

Undo

Raymond Longoria
PowerBuilder
Wednesday, 7 June 2023 22:18 PM UTC

I have a datawindow with 2 groups. In the group 2 trailer section, I have a computed field summing a column (ex. sum total for group 2). I need to sequence them by their total within each group 1 break. For example, let 's say group 1 has group A and B and in the group 2 trailer I will get rows with the sums. How can I sequence them within group 2 so that the sequencing begins in groups A and B? I hope that I communicated my question clearly.

Responses (1)

David Peace (Powersoft) Accepted Answer Pending Moderation

Tuesday, 13 June 2023 14:42 PM UTC
PowerBuilder
# 1

Hi Raymond

If I understand your question, you want to order the data in Group 1 by the totals of Group 2. I would approach this in the SQl and create a sub query column summing the totals for Group 2 rows and then order by that to get the right sequence. The DW should just work then.

Hope that helps.

David

Comment

There are no comments made yet.

Page :
1

There are no replies made for this question yet.
However, you are not allowed to reply to this question.

Please login to post a reply

You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »

Forgot Password?

We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.