Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
see attached file
hope this helps