Add column that can be use in Row pivot table

Hello   I am simplify my example to help you to understand my question So let say I have in my table 3 columns Date Hours Amount Example Date Hour Amount 23-May-21 19:47:08 50 ...