• 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.

How to use Group function in Pivot Table in Excel Sheet

A

Advocateabdulkhadershaik

New Member
I have three columns in an Excel Sheet -> Day of the week(Mon-Sun), 24 hr Timeline(0-24), number of entries.
In the process of finding which consecutive 2 hours had the highest number of Entries, the 'Group' function isn't showing all the results... I want like '0-2,1-3,2-4,3-5 etc' but the group function is displaying '0-2,3-5,6-8 etc'.
Is there any other function besides 'Group' that solves my problem..?
 
You've discovered that a given record can't contribute to more than one group in a pivot table.
You might be able to sort the data, chart it then add a moving 2-hour total (average) trendline.
Let's have some realistic data to experiment with.
 
You must log in or register to reply here.
Back
Top