Hi
I have a Table as follows
Date Day Amout1 Amount2 Amount3 Amount4
==============================================
17-05-2019 Friday 7072.00 9605.00 565.00 11287.00
18-05-2019 Saturday 7213.00 9879.00 523.00 13233.00
19-05-2019 Sunday 12587.00 17009.00 1962.00 15220.00
20-05-2019 Monday 23811.00 7019.00 358.00 4622.00
21-05-2019 Tuesday 28595.00 11132.00 486.00 3151.00
22-05-2019 Wednesday 4503.00 7858.00 470.00 6494.00
23-05-2019 Thursday 8995.00 9936.00 491.00 5837.00
24-05-2019 Friday 16742.00 11241.00 1415.00 5290.00
25-05-2019 Saturday 9268.00 9128.00 552.00 8568.00
26-05-2019 Sunday 11971.00 15342.00 627.00 15390.00
27-05-2019 Monday 6532.00 8524.00 1182.00 7718.00
28-05-2019 Tuesday 10389.00 9153.00 605.00 4952.00
29-05-2019 Wednesday 2756.00 11361.00 565.00 7760.00
30-05-2019 Thursday 11397.00 11334.00 773.00 6202.00
31-05-2019 Friday 8976.00 10054.00 480.00 5947.00
01-06-2019 Saturday 14241.00 13978.00 418.00 12184.00
Day is a formal to bring the date field with the date format "dddd". Therefore displayed as the day
I would like to create a pivot table with the Day wise summary where the total of Amounts need to be displayed as a summary for Sunday, Monday, Tuesday and so on.
Expecting a Pivot as below
DAY SUM OF AMOUNT1
=====================
Sunday Sum of Amount1
Monday Sum of Amount1
Tuesday Sum of Amount1
Wednesday Sum of Amount1
The issue I am facing is with the Day field. System is reading the same as "dd/mm/yyyy" and not as "dddd" for the data does not sorted/summarised by day.
Please help.
Bookmarks