Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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;
Hi StarinieriG,
Thats perfect, thank you very much.
Felix