On Feb 4, 10:01 pm, "Bernie Deitrick" <deitbe @ consumer dot org
wrote:
Michael,
If you use your "Weeks Open" field as a row field (the left-most is better) you can right-click it
and choose group, and then fill in the step as 2, 3, 4 whatever...
HTH,
Bernie
MS Excel MVP
"Michael.Tarnowski" wrote in message
...
Hi experts,
I have an application to track action item status - "open", "close",
"postponed", and "overdue".
For this I set up the source data to give these info as well the year
and calendar week. This I pivoted and charted to get the amount of
"open", "close", "postponed", and "overdue" items per week/year. It
works well.
Now I want to get a picture how long items remain open, similar to:
http://www.iceincusa.com/16CSP/content/gifs/mm_3.gif
For this I extended my source data and the corresponding PT by the
additional columns "days open" (=TODAY()-showUpDate) and "weeks
open" (=ROUND(daysOpen/7;0) for each item entry.
Example: for an item showed up at 2008-06-17 and being still open, the
days open are 232 and the weeks open are 33.
A pivot chart is showed byhttp://tinyurl.com/bh2zg4
But, now I want to show the values of "weeks open" as clusters of 2
(or an individual defineable range)
How should I set up my source data / PT? --- Do I need "helper
columns" for each class?
Thanks for your assistance!
Michael
Bernie,
GREAT! - it works.
Does Grouping works only by row fields? - Sorry for my ignorance, but
I'am narrowing down myself to secrets of PTs ;-)
Michael