How can I make 'Show all values' in a Pivot Table work?

[#1]

Hello

I want a Pivot table to display data in this layout.

Location	Weekday	Monday		Tuesday		Wednesday		Thursday		Friday
		Mor	Aftn	Mor	Aftn	Mor	Aftn	Mor	Aftn	Mor	Aftn
Loc_A
Loc_B
Loc_C

This works well on high level aggregation.

Making selections, columns can disappear because no data are available for that column.

For eg.

Location	Weekday	Monday		Tuesday		Wednesday	Thursday		Friday
		Mor	Aftn	Mor	Aftn	Mor	Mor	Aftn	Mor
Loc_A
Loc_B
Loc_C

Wednesday and Friday afternoon are left out.

I’ve tried the “Dimension” checkboxes “Show all values”, unchecked “Suppress when Values is null” and checked the “Presentation” checkbox “Always fully expanded” and unchecked “Suppress Zero-Values” to keep the layout as above.

What should I do to keep the original layout?

[RSvebeck · Accepted solution]

Hi

Add this to your expression:  +sum ({1} 0)

Your expression will then be : Count (Kin_Naamkind) +sum ({1} 0)

Hope it helps,

best Regards,

Robert

[Gysbert_Wassenaar]

Kan je zo snel mogelijk je bestand vervangen door eentje zonder privé gegevens van de ouders?

Zie hier voor hoe je gegevens 'veilig' kan maken: Preparing examples for Upload - Reduction and Data Scrambling

[#4]

2 options:

1) handle it in sql - use nvl()

2)in presentation tab- fill 'null symbol' & 'missing symbol'

Also, check 'Show All Values' for all dimensions.

[bruno_m_santos]

Try use NullasValue to that column in script;