See example: http://1drv.ms/1jvsYhJ
Latest version of XBRLAnalyst released yesterday introduces new functionality in XBRLFact function that greatly facilitates the use of Pivot Tables in Excel. XBRLFact can now accept columns of input parameters as an array function and return thousands of results in one request. It really shows how to leverage XBRL data in Excel effectively. One can get data for hundreds of different XBRL tags in individual reports of selected companies or create new financial ratios as built-in “My Definitions” and caculate all of them fast! View the example here: http://1drv.ms/1jvsYhJ.