Help with Pivot table and grouping

[bdaoust]

I am creating a pivot table that measure the time to place a case using
DateReceived and Date Approved. The TimeToPlace would be by pivot and
I want to have grouping of 15 like so:

0-15 days
16-30 days

etc

This is a calculated field. The problem is that sometimes it hasnt
been Placed yet and is pending. So one would think - well use an if -
do a calculated and return 0 if you have to.

Well cases can be received and placed the same day, so 0 days cant be
used for pending.

I tried returning false, but then I cannot group based on that
TimeToPlace because false or null is in there.

Any sugggestions?

-Brian

 

[Debra Dalgleish]

You could add a column to the source data, and calculate the
TimeToPlace. Then, add that field to the pivot table.

 

[bdaoust]

Hello Debra,

That is what I am doing. Problem is - sometime TimeToPlace is null
since it hasnt been approved and therefore is still pending. I need
pending to be in its own count bucket since 0 is a valid return
(received and approved on the same day)

Thanks,
Brian

 

[Debra Dalgleish]

When you mentioned calculated field, I thought you were calculating it
in the pivot table.

You could manually select and group the numbers in the pivot table.

Or, in the source table, you could use another column to calculate the
grouping, referring to a lookup table, e.g.:

0 0-15
16 16-30
31 31-45
46 46-60
61 61+

Then, add that field to the pivot table.

Hello Debra,

That is what I am doing. Problem is - sometime TimeToPlace is null
since it hasnt been approved and therefore is still pending. I need
pending to be in its own count bucket since 0 is a valid return
(received and approved on the same day)

Thanks,
Brian

 

[bdaoust]

Great! Thanks for the help.

-Brian

When you mentioned calculated field, I thought you were calculating it
in the pivot table.

You could manually select and group the numbers in the pivot table.

Or, in the source table, you could use another column to calculate the
grouping, referring to a lookup table, e.g.:

0 0-15
16 16-30
31 31-45
46 46-60
61 61+

Then, add that field to the pivot table.