• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

monthly total of horizontal date data

F

FIZA

New Member
Hi,

I have sign up today. As am unable to find here on site.
my data is listed horizontally
Colm A: 1st jan
COlm B: 2nd jan
Coulm C: 3rd jan

Row1: Emp1
Row2: Emp2
Row3: Emp3

At the bottom am getting total of day total (column wise)
At the right end, am getting emply total

Now this list is continous date wise till dec.
i want monthly , weekly ,total, but in pviot i cant do as my data is listed in above form.

pls help
 
If you have control over how the data is listed then I think you would be better served if you listed it something like:

Name Date Qty
Bob 1/1/2015 5
Pete 1/1/2015 9


Then you can more easily use a pivot table to summarize as you have explained.
 
Hi Fiza,
Your dates looks like text strings (not actual dates).
You may need to replace your dates with actual dates for pivot to work better.

Can you post a sample of your file?
This will help users to provide you targeted solution.

Regards,
 
You must log in or register to reply here.
Back
Top