cancel
Showing results for 
Search instead for 
Did you mean: 

Continuous Date for null values not coming

vaibhav_rathore
Participant
0 Kudos
148

Hi All,

I have a requirement to show the continuous date (horizontal header) in crosstab header for the quantity sold and Item ID's(vertical header). The date must come even if there is no quantity sold and that column can appear blank.

Date=Planned date+lead months

for example: Jan-22+4=May-22

created variable:

v1=relativedate(planned date;lead months;monthperiod)

this will give me the date plus lead months.

I am using this v1 in the crosstab header. This is working fine if no filter is applied on the Item ID's but as soon as we select any Item ID then only those dates appear which has the quantity sold for this Item ID. I need to show all the dates either blank or not.

Any solution will be helpful.

Thanks

vaibhav_rathore
Participant
0 Kudos

Also tried with Timeedim() fun but its not working. Please advise

Accepted Solutions (0)

Answers (1)

Answers (1)

amitrathi239
Active Contributor
vaibhav_rathore
Participant
0 Kudos

Hi amit.kumar71 Yes i tried your logic but its giving #multivalue for all the quantities now

as you can see in the attached screenshot i am not getting Dec-22 and other dates for the filtered Item ID.

Please advise.