This content has been marked as final. Show 4 replies
I've a pivot table like this:
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 ?
Thanks in advance