Does anybody know if the EXPANDABLE ON function which produces an accordion report works in Excel?

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

No, EXPANDABLE is for HTML only. It is all based on Javascript which is an unknown entity in Excel.

OK, very disappointing but actually not far from what I expected. I had already researched the documentation but was curious to see if anybody had been able to work with it in Excel.

Thanks a lot for your prompt response!

EXL2K PIVOT is the best you can do

Thank you JG. I actually was just doing the research on that to see if PIVOT will give me the results I want.

quote:

Originally posted by JG:
EXL2K PIVOT is the best you can do

what effect does pivot have on a field with % values?

on the summary level % just gets adds up, instead it should be doing a recompute.
please help