Different orden and sum for total.

[Anonymous]

Hello,

i have the following data.

Family, Sales

1,23

2,65

3,76

And i would like to have the following output in a pivot table.

Family,Sales    

1,23

2,65

Total,88

3,76

as you can see, the total is the sum of family 1 and 2.

i have created a family name total and then on the expression i have done a sum total for family 1 and 2.

¿is there any other way?

thank you

[swuehl]

Yes, create a link table:

LOAD * INLINE [

     Family, FamilyDim, FamilyDimSort

     1,1,1

     2,2,2

     1,Total,3

     2,Total,3

     3,3,4

];

Use FamilyDim as dimension and =FamilyDimSort as sort expression.

Expression is just

=Sum(Sales)

[Frank_Hartmann · Accepted solution]

see attached file

hope this helps