Prev: SaveAs
Next: Copy/Paste cells containing only numbers with .50 in it
From: dstiefe on 2 Jun 2010 09:56
I have a pivot table with two levels of columns headings..so for example

I have Period of the Month...and then under that...week in period...each
period has 4 weeks..

but sometimes I may only have 1 week in a period..

how can i read the pivot table and determine how many weeks in a period are
actually displayed?

thank you

I am willing to send the file if you reply with an email address
From: dstiefe on 2 Jun 2010 15:02
t

"dstiefe" wrote:

> I have a pivot table with two levels of columns headings..so for example
>
> I have Period of the Month...and then under that...week in period...each
> period has 4 weeks..
>
> but sometimes I may only have 1 week in a period..
>
> how can i read the pivot table and determine how many weeks in a period are
> actually displayed?
>
> thank you
>
> I am willing to send the file if you reply with an email address
 | 
Pages: 1
Prev: SaveAs
Next: Copy/Paste cells containing only numbers with .50 in it