totals in pivot table

[Anonymous]

Hi,

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

[whiteline · Accepted solution]

Hi.

The function dimensionality() could be used to check if the expression is calculating for totals:

=if(dimensionality()<>0, concat(...), null())

[Anonymous]

I'm sorry, but I don't understand where I've to insert this function.

I would insert a condition to display subtotals, but I don't know how to do it

[whiteline]

You just have to modify expression for References so that not to calculate it for the total row.

[Anonymous]

Thanks very much !!!!