Summary field sorting

[pungigi]

I have a formula A that sums 3 formulas (1+2+3) together, what I now want is to sort on formula A in descending order, it is not appearing as an option can anyone help??

 

[bdreed35]

Have you tried using Top N? Try Report, Top N Sort/Group Expert. Base it off of your Sum above and select descending.

If you are having troubles still, please post a sample layout that identifies the sections.

~Brian

 

[pungigi]

Page Header
Client Name
Group Header
Member Name Member Number Jul Ct Aug Ct Sep Ct QTD Ct
Lisa Smith 123 1 0 3 4
Jane Doe 456 0 0 1 1
John Michael 789 3 5 0 8
Eva Dawn 012 0 2 4 6

I want it to look like...
John Michael 789 3 5 0 8
Eva Dawn 012 0 2 4 6
Lisa Smith 123 1 0 3 4
Jane Doe 456 0 0 1 1

Here are my formulas
Jul Ct if {_MTMTRP.TAPTDT} >= 20030701
then if {_MTMTRP.TAPTDT} <= 20030731
then 1
else 0
Aug Ct if {_MTMTRP.TAPTDT} >= 20030701
then if {_MTMTRP.TAPTDT} <= 20030731
then 1
else 0
Sep Ct if {_MTMTRP.TAPTDT} >= 20030701
then if {_MTMTRP.TAPTDT} <= 20030731
then 1
else 0
QTD Ct Sum ({@Jul Apt}, {_MTMTRP.TCSTKY}) + Sum ({@Aug Apt}, {_MTMTRP.TCSTKY}) + Sum ({@Sep Apt}, {_MTMTRP.TCSTKY})

When I go through report, top N/Group sort, the QTD formula is not a choice.

Thanks again for any help you can give.

 

[bdreed35]

Here is what you need to change:
Change your QTD count formula to add the Jul, Aug, & Sep formulas at the detail level

{@Jul Apt} + {@Aug Apt + {@Sep Apt}

Now create a summary based upon the new QTD formula above.
Insert, Summary...sum on @QTD for the {_MTMTRP.TCSTKY} group.
Place that where you had your your @QTD formula before.

You should now have @QTD available in the Top N Expert.


~Brian