BharathBabu
New Member
Hi,
I have a query in the pivot table...
How to get the blank cell in the pivot table. i used the formula
=IF(ISERROR(VLOOKUP(Data!C2,Data!$C$2:$C$30,1,0)),"",VLOOKUP(Data!C2,Data!$C$2:$C$30,1,0))
Data:
A1: Company Name, B1---> Date, c1-----> Gold, D1---->Silver & E1----> Status
Customer Name-----Date------Gold------- Silver--------Status
TCS---------------1-Jan-13----2 --------Nil-----------pending
APS---------------1-Jan-13----Nil--------20-----------completed
INDUSTRIAL--------1-Jan-13-----15--------Nil----------pending
TEXAS FIRST-------2-Jan-13-----25-------Nil-----------pending
CIRCLE------------2-Jan-13-----Nil-------10-----------completed
When I create the Pivot table for the above data...it show the below table
Row Labels-------------completed-------pending------Grand Total
TCS
Sum of Gold------------blank cell----------2---------2
Sum of Silver----------blank cell----------0---------0
My query is, how to get pending "Sum of sliver" should be blank cell instead of "0"....
Please advise....
I have a query in the pivot table...
How to get the blank cell in the pivot table. i used the formula
=IF(ISERROR(VLOOKUP(Data!C2,Data!$C$2:$C$30,1,0)),"",VLOOKUP(Data!C2,Data!$C$2:$C$30,1,0))
Data:
A1: Company Name, B1---> Date, c1-----> Gold, D1---->Silver & E1----> Status
Customer Name-----Date------Gold------- Silver--------Status
TCS---------------1-Jan-13----2 --------Nil-----------pending
APS---------------1-Jan-13----Nil--------20-----------completed
INDUSTRIAL--------1-Jan-13-----15--------Nil----------pending
TEXAS FIRST-------2-Jan-13-----25-------Nil-----------pending
CIRCLE------------2-Jan-13-----Nil-------10-----------completed
When I create the Pivot table for the above data...it show the below table
Row Labels-------------completed-------pending------Grand Total
TCS
Sum of Gold------------blank cell----------2---------2
Sum of Silver----------blank cell----------0---------0
My query is, how to get pending "Sum of sliver" should be blank cell instead of "0"....
Please advise....