Pivot Table Help

[dimitrz]

Hi all

Okay this is what I am looking for

I have raw data with date & days of the month .

From this raw data I want to get the collective sums for each day of the week using Pivot or any other means - I tried Pivot but propabaly due to lack of my understanding of the same the desired result was not recived

I have enclosed a sample file below

Thanks in advance

[arthurbr]

Hi,
a PT seems to do the trick

[dimitrz]

Thank you - I got the logic of arranging it

[arthurbr]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save