![Getpivotdata Getpivotdata](/uploads/1/2/5/5/125588687/489545657.png)
![Mac Mac](/uploads/1/2/5/5/125588687/287490707.png)
Return blank cell instead of zero using GETPIVOTDATA (Excel for Mac 2011). If this is your first visit, be sure to check out the by clicking the link above. You may have to before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.
Also, to ensure that your UserName is registered, please ensure that you have confirmed your e-mail address by clicking on the link that will be sent to your address. Users who do not confirm their e-mail addresses will be able to browse the forum, but not able to download any content. Trying to use ISERROR and ' (see formula below) to return blanks instead of zeros for a table that holds sales data for the calendar year - need values for months that have no sales data to register as blanks instead of zeros to ensure accuracy of charts that are based on table.
Am using Excel for Mac 2011. =IF(ISERROR(GETPIVOTDATA('Sum of Total Price (converted)',$1:$1048576,'Sales Operations Location','US','Close Month','5/1/12')),',GETPIVOTDATA('Sum of Total Price (converted)',$1:$1048576,'Sales Operations Location','US','Close Month','5/1/12')) Any help that can be provided is much appreciated!
The named lists ensure that only non-blank values are displayed to the user. Once we have all the lists ready, we simply create a dummy pivot table and then use cell validation feature to create the drop-downs. We add getpivotdata() formula to fetch the values from the pivot table as per users selection.