Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi.
The function dimensionality() could be used to check if the expression is calculating for totals:
=if(dimensionality()<>0, concat(...), null())
Hi.
The function dimensionality() could be used to check if the expression is calculating for totals:
=if(dimensionality()<>0, concat(...), null())
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
You just have to modify expression for References so that not to calculate it for the total row.
Thanks very much !!!!