Drill down in a spreadsheet component

sunilsagar
sunilsagar used Ask the Experts™
on
Hi,
I need to create a pivot table in xcelsius. I know currently xcelsius doesnot support pivot table. I am thinking of achieving this by first creating the pivot it excel and then just displaying it AS IS.
Then it need to develop a drill down feature so that whenever any of the cell in the pivot table to clicked it pops a separate window showing a detailed spreadsheet giving the details about the aggregation.
Please let me know if you need more information.

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Professor of MIS at Penn State Erie and Owner, Millet Software
Commented:
One of the 3rd-party Crystal Reports Desktop Schedulers listed at http://kenhamady.com/bookmarks.html allows you to automate the process of generating an Excel pivot table from a Crystal report (as well as emailing it if needed).
Top Expert 2011
Commented:
If you need just a pivot table - there are free Crystal reports viewers, which support pivot tables natively. However, for a pivot table with drilldown capabilities you will need a custom application
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet Software
Commented:
Also one of the 3rd-party Crystal Reports Viewers listed at http://kenhamady.com/bookmarks.html provides interactive data visualization & pivoting, including drilling into detail (not via a double-click but by right-click menu option of 'View Underlying Data').

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial