Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a report where I want to print a pivot table on two pages and one of my dimensions is in the columns.
Is it possible to set a pagebreak for this dimension. (I already tried to use 'Conditional break' without result).
Thanks.
Kind regards,
Guy
The breaks in pivot table works other way, where you say how QV deals with the change of the dimensions.
I Don´t lknow how your report looks like but, if it has a fixed number of rows you can create a calculated dimension grouping the rows in two parts, then use the forced break.
The calculated Dimension (Page) formula should be " if([Report Line]<=3, '1' ,'2')
The result is something like:
BEFORE
AFTER
Report Line Value
1 1000
2 2000
3 3000
4 4000
5 5000
6 6000
Page Report Line Value
1 1 1000
1 2 2000
1 3 3000
2 4 4000
2 5 5000
2 6 6000
Mr Fernando,
Thanks, but I would like to apply this page break to the columns, this means for example dimensions values 1 to 7 (first 7 colums) on page 1 and values 7 to 12 (columns 7 to 12) on page 2. Within each dimesion value I have results for 3 expressions ( total resultcolums:36).
Kind regards,
Guy
Ok, page breaks only works for rows.
But you can create a calculated dimension showing only some values in the dimension you use as column. Then you can either have 3 charts or a field (like the previous "Page" one) that maps your columns in pages.
To print this create a Document Report with the 3 charts or with One chart that loops through the Page field.
hope it helps this time
Fernando
Fernando,
OK, I managed to create the calculated dimension and named it "Page" but when I'm trying to set up a report with a loop I can't find my calculated dimension-field in the list that says that that's the field to loop through.
Kin,d regards,
Guy