These functions are organised into categories (text, logical, math, etc.) to help you to locate the function you need from the Excel menu. (elFrom.tagName="A" & elFrom.Excel provides a large number of built-in functions that can be used to perform specific calculations or to return information about your spreadsheet data. (elTo.tagName="A" & elTo.parentElement!=elFrom) ||
If (fnScrollTabs(fDir)>0) tTimeout("fnFastScrollTabs("+fDir+") ",5) Return parseInt(ua.substring(msie+5,ua.indexOf(".", msie))) = cut here from the next line on & save as a HTML file Snip and save as a HTML file and view in the browser to see what I mean I am attaching below a webpage so this is more obvious. If there is an alternate property I should be using, please let me know.Īny pointer or suggestions welcome. Unfortunately, RecordCount does not always return the right counts, so my computed offsets are sometimes wrong :-(. I even tried an alternate approach of generating cell references to the pivot table cells (in lieu of generating GETPIVOTDATA formulas) traversing through the RowFields(1).PivotItems & using the PivotItems.RecordCount to figure out the cell offsets. I am trying to write VBA code which will generate a table off the pivot table totals (the table should have each instance of the left most rowfield and the associated total from the pivottable) and I am completely stuck because of this bug. is there any way of specifying the GETPIVOTDATA to be able to access these custom calculation values.? Is this a known bug? Is there a workaround i.e.
I have tried playing around with formula generated to massage it to look like the first formula, but I cannot get this to work for custom formulas. Note that this generated formula does not even seem to conform to the GETPIVOTDATA documentated format. =GETPIVOTDATA($A$3,"ProductName 'Sum of CurrentPrice'") The GETPIVOTDATA formula generated (shown below) looks different than the one above and returns a REF error. Now, select the same total field & change this to a custom calculation - pick any type (1 selection will do). =GETPIVOTDATA("Sum of CurrentPrice",$A$27,"ProductName","CR20") In this case, the formula generated is of the form: You get the GETPIVOTDATA formula generated for the reference within the pivot table. Activate a cell outside the pivot table and click on the totals cell (Note: I am selecting the total for each value within the left most row field - i am not selecting the grand total). I am encountering this issue on Excel2003 on XP.Ĭreate a simple pivot table (my example has 2 row fields).
0 kommentar(er)
