Order a Pivot Table for Expression

[#1]

Hello to all

I have a pivot table, and want to order it for volume, descended. I ordered the dimesion chains for expression, descending, in this case SUM(volume), but, when the volume is zero is it at the beginning of the list and not at the end.

Thanks

[#2]

In the pivot chart properties, tab Sort.

Check Expression and select Descending, then in the expression window just below that type in =sum(vol)

regards,
FC

[#3]

Thanks,

The Sum add in the expression, but continuous first the values zeros.

This is the expression:
=num(sum ({$<d_anio = {*}, d_mes = {*}, dia_del_mes = {*}, Fecha_num = {$(vPeriodo)}>} Vol))

Sum the volume for a period of time.

[#4]

In the Dimensions tab of the chart/pivot try to check the box "Surpress when value is Null" in the Settings for selection Dimension