Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I have a large pivot chart and need to add some formatting to it.
Ive attached a sampe xls of how the chart is currently being printed (TABLE1) and how I need to show it (TABLE2). Is there any way to split a pivot up on a dimension?
Many thanks for your help!
Fiorano
can u provide any sample application?
Thanks
Sushil
Hello,
In your pivot chart, go to 'Dimensions' tab :
You will find 'Page Breaks' option a the bottom right corner. If you chose 'Forced breaks', your chart will start on new page (multiple page report) for every value in your dimension.