Hello Everyone.
I have a table with following field (that calculate delay codes of Flights operation)
I need to create a pivot table that sum the time of each delay code in the 3 columns into 1 (1st_Delay_Code / 2nd_Delay_Code / 3rd_Delay_Code)
I’m able to summarize the time of each column individually as following
But I do not know how to list the 3 columns into 1
The result is always wrong showing something like below
Can someone help me with that.
Thanks in advance for your time
I have a table with following field (that calculate delay codes of Flights operation)
I need to create a pivot table that sum the time of each delay code in the 3 columns into 1 (1st_Delay_Code / 2nd_Delay_Code / 3rd_Delay_Code)
I’m able to summarize the time of each column individually as following
But I do not know how to list the 3 columns into 1
The result is always wrong showing something like below
Can someone help me with that.
Thanks in advance for your time