Hi
I have used the standard pivot EFS in the formulas to calculate my monthly and weekly pivot and daily pivots. However i would like my daily pivots to be calculated using the timeframe of the previous days 05:00am to todays 05:00am.
Would be very grateful for any help
Thanks
I have used the standard pivot EFS in the formulas to calculate my monthly and weekly pivot and daily pivots. However i would like my daily pivots to be calculated using the timeframe of the previous days 05:00am to todays 05:00am.
Would be very grateful for any help
Thanks