How to get same value as above row

Question

Hi all,&nbsp;Below i have 2 data of order (10000776769 &amp;&nbsp;10000589016).&nbsp; How can I get all actual date row follow the same date as ZN01 date.&nbsp;Current Actual date formula: if AFVC="ZN01" then Date else 0&nbsp;OrderAFVCValueDateActual Date10000776769ZN0105/6/20235/6/202310000776769ZN0207/6/2023010000776769ZN0307/6/2023010000776769ZN0437/6/2023010000776769ZN05567/6/2023010000776769ZN0607/6/2023010000776769ZN0707/6/2023010000776769ZN0807/6/2023010000776769ZN0907/6/2023010000776769ZN10787/6/2023010000776769ZN1117/6/2023010000776769ZN1207/6/2023010000776769ZN1307/6/2023010000589016ZN0102/6/20232/6/202310000589016ZN0203/6/2023010000589016ZN0303/6/2023010000589016ZN0403/6/2023010000589016ZN0523/6/2023010000589016ZN0603/6/2023010000589016ZN0703/6/2023010000589016ZN08293/6/2023010000589016ZN0913/6/2023010000589016ZN10663/6/2023010000589016ZN1103/6/2023010000589016ZN1203/6/2023010000589016ZN1303/6/20230&nbsp;Regards,Nuha

m_dekorte · Answer

Hi&nbsp;Anonymous,&nbsp;If you want to repeat the same "Actual date" for the other order records, use null instead of 0 in your conditional column and subsequently select the fill down option.&nbsp;Note that this requires there has to be an&nbsp;AFVC="ZN01" for each order in your table.

anonymous · Answer

hI&nbsp;m_dekorte&nbsp;,&nbsp;&nbsp;I dont think your solution will solve my issue here. I do change the value 0 to NULL but I still stuck at this point. I want the value as below image aligned in each row (3 rows = 3 different date = 1 production order)&nbsp;&nbsp;Regards,Nuha&nbsp;&nbsp;

m_dekorte · Answer

Right click the column header/ Fill/ Down&nbsp;

anonymous · Answer

Hi&nbsp;m_dekorte&nbsp;,&nbsp;Already done the step but it not fulfill my requirement. This is because not all date are in sequence as below.&nbsp;&nbsp;OrderAFVCValueDateActual Date10000776769ZN05&nbsp;&nbsp;&nbsp;10000776769ZN0207/6/2023010000776769ZN0307/6/2023010000776769ZN0437/6/2023010000776769ZN13567/6/2023010000776769ZN0607/6/2023010000776769ZN0707/6/2023010000776769ZN0807/6/2023010000776769ZN0907/6/2023010000776769ZN10787/6/2023010000776769ZN1117/6/2023010000776769ZN1207/6/2023010000776769ZN0105/6/20235/6/202310000589016ZN0102/6/20232/6/202310000589016ZN0203/6/2023010000589016ZN0303/6/2023010000589016ZN0403/6/2023010000589016ZN0523/6/2023010000589016ZN0603/6/2023010000589016ZN0703/6/2023010000589016ZN08293/6/2023010000589016ZN0913/6/2023010000589016ZN10663/6/2023010000589016ZN1103/6/2023010000589016ZN1203/6/2023010000589016ZN1303/6/20230

Forum Discussion

How to get same value as above row

4 Replies

Related content

Replacing a cells value if value of cell above meets condition

Matrix - Display Values above Columns

Have measure values above column hierarchy

Replace Cell Value with the Cell above

How to display values above line chart

Order	AFVC	Value	Date	Actual Date
10000776769	ZN01	0	5/6/2023	5/6/2023
10000776769	ZN02	0	7/6/2023	0
10000776769	ZN03	0	7/6/2023	0
10000776769	ZN04	3	7/6/2023	0
10000776769	ZN05	56	7/6/2023	0
10000776769	ZN06	0	7/6/2023	0
10000776769	ZN07	0	7/6/2023	0
10000776769	ZN08	0	7/6/2023	0
10000776769	ZN09	0	7/6/2023	0
10000776769	ZN10	78	7/6/2023	0
10000776769	ZN11	1	7/6/2023	0
10000776769	ZN12	0	7/6/2023	0
10000776769	ZN13	0	7/6/2023	0
10000589016	ZN01	0	2/6/2023	2/6/2023
10000589016	ZN02	0	3/6/2023	0
10000589016	ZN03	0	3/6/2023	0
10000589016	ZN04	0	3/6/2023	0
10000589016	ZN05	2	3/6/2023	0
10000589016	ZN06	0	3/6/2023	0
10000589016	ZN07	0	3/6/2023	0
10000589016	ZN08	29	3/6/2023	0
10000589016	ZN09	1	3/6/2023	0
10000589016	ZN10	66	3/6/2023	0
10000589016	ZN11	0	3/6/2023	0
10000589016	ZN12	0	3/6/2023	0
10000589016	ZN13	0	3/6/2023	0