Pivot Tables, Beginers Questions

CMIIandExcel

Board Regular
Joined
Sep 4, 2009
Messages
190
Hi all

I am trying to get to grips with pivot tables and have a couple of questions that will probably have very simple answers too.

1)

The data set i am working from has a percent compleate field which i was trying to group against. I tried various approaches but still could not get it working so I used a work around. In my original data set I used a formula to group the data (100%, 99-75%,74-50% etc), i allocated the data row to Group 0,1,2,3,4,5.

I have now have an issue of when the group has no data allocated to it,it does not appear in my table. i have tried the show items with no data checkbox but to no avail, the problem being i have no item in the first place.

I want to show in my table and graphs run from it that currently i have nothing at that status.

2)
Within the same data set i also have a field of working days to compleation which i have grouped using the grouping tool in blocks of ten.
as it draws closer to the compleation date i would like to track the data in more detail, is it possible to set up the following grouping; >60, 60-40,39-20,19-10,9-5, 4-2, 1, 0, <0 Days.

I Could use the same approach as i did in issue (1) but then would face the same problems as I have there.

Any help and advice would be warmly welcome.
Also any links to good beginers guides to pivot would also be recived with thanks.

Thanks in advance for any help

Regards

Mike
 

Forum statistics

Threads
1,082,106
Messages
5,363,185
Members
400,721
Latest member
eileen123

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top