Pivot Table - Arbitrary Sort

[Adrae]

Is there any way to add a secondary rank that would order the values within a group without creating more groups and subtotals?

Thanks

[Mark W.]

On 2002-02-20 06:10, Adrae wrote:
Is there any way to add a secondary rank that would order the values within a group without creating more groups and subtotals?

Thanks

Care to provide a simple example using less than 10 data list records? Please specify your desired result.

[Adrae]

I did an example in excel, but don't know how to attach it. Anyway, let me see if I can explain:

Here's the sample source data:
rank order Item Amount
1 2 Example 1 100.00
1 1 Example 2 100.00
1 4 Example 3 100.00
1 3 Example 4 100.00
1 5 Example 5 100.00
2 5 Example 6 100.00
2 4 Example 7 100.00
2 1 Example 8 100.00
2 2 Example 9 100.00
2 3 Example 10 100.00

Here's how I want it to appear:
Total
1 Example 2 100
Example 1 100
Example 4 100
Example 3 100
Example 5 100
1 Total 500
2 Example 8 100
Example 9 100
Example 10 100
Example 7 100
Example 6 100
2 Total 500
Grand Total 1000

I wasn't able to include all the borders to make it look more like an actual pivot table, but you get the idea. Notice how it sorts the individual examples within each group (1 & 2) according to the order but without adding subtotals. Can this be done?
Thanks

[Mark W.]

On 2002-02-20 07:16, Adrae wrote:
I did an example in excel, but don't know how to attach it. Anyway, let me see if I can explain:

Here's the sample source data:
rank order Item Amount
1 2 Example 1 100.00
1 1 Example 2 100.00
1 4 Example 3 100.00
1 3 Example 4 100.00
1 5 Example 5 100.00
2 5 Example 6 100.00
2 4 Example 7 100.00
2 1 Example 8 100.00
2 2 Example 9 100.00
2 3 Example 10 100.00

Here's how I want it to appear:
Total
1 Example 2 100
Example 1 100
Example 4 100
Example 3 100
Example 5 100
1 Total 500
2 Example 8 100
Example 9 100
Example 10 100
Example 7 100
Example 6 100
2 Total 500
Grand Total 1000

I wasn't able to include all the borders to make it look more like an actual pivot table, but you get the idea. Notice how it sorts the individual examples within each group (1 & 2) according to the order but without adding subtotals. Can this be done?
Thanks

Make your ROW area fields: 'rank', 'order',
'Item' (in this order). Double-click the
'order' field button and set its Subtotals
to "None". If desired hide the column
containing the 'order' field.