Pivot Table

[mario-sarkis]

hey all i need help

i have this example in a pivot table

ID    Volume

1      x

2      x

3      x

4      x

5    x

6     x

7     x

8     x

9     x

this table is filtered by a field , once i select on this field in the some ID doesn't belong to this field will not show in the table

Ex:

ID    Volume

1      x

2      x

3      x

5      x

6     x

8     x

9     x

my request is to show them all

ID    Volume

1      x

2      x

3      x

4      0

5     x

6     x

7    0

8     x

9     x

please help

[Gysbert_Wassenaar]

Try disabling the option Suppress Zero-values and use an expression like sum(Volume)+sum({1}0)