How to display all pivot columns?

[felix_kraemer]

Dear all,

I hope someone can help me. 

I have attached expample where I want to show the SUM(Value) for all Spaces and all CALDate in below pivot.

What should I do to display CALDate 06.01.2020 where no Space has any values?  

Thank you,

Felix 

[StarinieriG · Accepted solution]

Hi,

to do that, you have to create rows.

For example you could try in this way:

NoConcatenate
TEMP:
LOAD
Date
Resident MasterCalendar;

Left Join (TEMP)
LOAD distinct
Space
Resident testtable;

Left Join (TEMP)
LOAD *
Resident testtable;

Drop Table testtable;

[felix_kraemer]

Hi StarinieriG,

Thats perfect, thank you very much.

Felix