Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
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
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.
Try use NullasValue to that column in script;