Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

size of pivot table

Hi,  I've attached a word doc with a screen shot of my QV page.  I have pivot tables below all my graphs (see attachment).  I would like to pivot table to always be the same size as the graph.  Right now I have dimension limits in there to limit the box to 18 months ( from today's date).  That works somewhat but depending on the time of the month, I get 17 or18 months hence the size of the box changes.   Any ideas?  I would like to always have it limited to 18 periods.  Thanks, Jim

1 Solution

Accepted Solutions
whiteline
Master II
Master II

Uncheck 'Size To data' checkbox on Layout tab in pivot properties.

View solution in original post

2 Replies
whiteline
Master II
Master II

Uncheck 'Size To data' checkbox on Layout tab in pivot properties.

Not applicable
Author

You da Man!! Thank you!