Get all the values in a single line

[Vinay_47]

 

I had a group named Airtel and it had a date called standby date and it has values from 01-01-25 till 31-01-25

I have added columns for current date -2, current date -1 , current date , current date +1 , current date +2 ,followed by +3,+4,+5

My requirement is if there is standby date which equals my above current date column values then it should have X else it should be null. The groups should not be duplicated  as per the screenshot. It should come in a single line.

Attached screen shot for reference

[ayman_salem · Accepted solution]

One possible solution is to use the cross table with the following variables:

v_Standby_C:   =If ([Standby Date] >= RelativeDate(CurrentDate();-3;DayPeriod) And [Standby Date] <= (RelativeDate(CurrentDate();6;DayPeriod ))) Then [Standby Date] 

v_X:   =If ([Standby Date] = [v_Standby_C]) In ([Airtel];[v_Standby_C]) Then "X"

..

I hope it helps and this is what you are looking for

[ayman_salem]

Is every Airtel has multi -standby date?
Are you defined for each column a variable/formula (8 variable for 8 columns) or have you received it from your data?

An example -raw data and the variable you defined are useful to correctly understand your question and give you the correct answer:

[Vinay_47]

Yes it has multi values for stand by date. Yes each column is created with 8 different variables.