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

instead of having in my Pivot

• Date in (rows)
• and sum of amount in (Values.)

I add a colum in power pivot called shift like this

=if(hour>16:00,Date & "A", Date & B)

So my data is like this

I would like to use in my pivot table

• Shift in (rows)
• and sum of amount in (Values.)

But I get error that I can move calculated field there.

What I can do? to be able to do it. what is the correct way.

thanks