4 Replies Latest reply: Nov 4, 2012 2:07 PM by steve peroni RSS

    totals in pivot table

    steve peroni


      I've a pivot table like this:

                                                                    Year                                             Year-1

      Country Customer     TotalSales                 Sales%     References                    Sales%     References

      USA         A                    1000                         10          SO_1234 - SO_1234        5%          SO_xyz  - SO-nmm


      The reference field is the concat of sales order reference

      If I choose the sub-total for country, the reference field is the concatenation of all customer reference (in my example SO_1234 - SO_1234 - SO_xyz  - SO-nmm)

      How can I avoid this fact ? Really I don't need the total for a non numeric field.


      Is it possible ?

      Help, please

      Thanks in advance