I have searched FocalPoint, and read the manual on Pivot Tables, but can't find anything to tell me if it's possible to have compound pivot tables. Is this possible to do? I keep getting an error that it doesn't like the word 'open'.

Thanks,

Linda

This message has been edited. Last edited by: linus,

Yes it is possible to have a compound pivot tables. The below example may help you. If this is not what you are expecting please post your sample code so that we can help you better.

  
SET COMPOUND = OPEN
TABLE FILE CAR
HEADING
"Car Report By Country"
PRINT
SALES AS 'Sales'
BY COUNTRY
ON TABLE PCHOLD FORMAT EXL2K PIVOT
ON TABLE SET STYLE *
TYPE=REPORT,
TITLETEXT='Summary Country Report', $
TYPE=HEADING, SIZE=16, $
TYPE=TITLE,BACKCOLOR=RGB(184 204 228),$
ENDSTYLE
END


SET COMPOUND = CLOSE
TABLE FILE CAR
HEADING
"Car Report By Model"
" "
PRINT
SALES AS 'Sales'
BY MODEL
ON TABLE PCHOLD FORMAT EXL2K PIVOT
ON TABLE SET STYLE *
TYPE=REPORT,
TITLETEXT='Summary Model Report', $
TYPE=TITLE,BACKCOLOR=RGB(184 204 228),$
ENDSTYLE
END

Thank you,
Arun

Thanks...my original code dynamically set an &VAR that I placed in my ON TABLE HOLD statement as I loop through my code, depending on the loop ctr. I've changed it to an &VAR that is either set to 'SET COMPOUND = value' or '-*'. I'm working on it now, just getting everything to increment and change to the right value when necessary. Thanks...

It's working! Thanks!
How do I mark this as 'Resolved'?

if you edit your original post, you can change the subject heading. Just put [Solved} at the beginning of the post and it will be considered closed.