Excel Formula - IFError and PIvot table Getdata [SOLVED]

[ianb]

=IFERROR(GETPIVOTDATA("Incident ID+",'PSO R&C Table'!$A$3,"Group*+","User Security","Resolved Month / Year","Oct-13"),"0")


I would like to change this from Oct-13 to the cell reference on the data sheet.


e.g. =IFERROR(GETPIVOTDATA("Incident ID+",'PSO R&C Table'!$A$3,"Group*+","User Security","Resolved Month / Year","A30"),"0")


The format is mmm-yy yet this does not work as I think it is custom not date when I look in the cell ref it is showing 01/07/2013 hence the display is Oct-13. This is required to display in the charts etc. any ideas then I can copy and past the formula instead of changing each formula in each cell.


I have tried to change to the General Format yet this will give me a string of numbers e.g. 41609

 

[sgmpatnaik]

@Ianb


HI


I think it is not a simple question as per your posts is 235 i think your formula should like this


=IFERROR(GETPIVOTDATA("Incident ID+",'PSO R&C Table'!$A$3,"Group*+","User Security","Resolved Month / Year",A30),0)


hope it will give you correct answer if not please inform


Thanks


SP

 

[ianb]

I have found the answer.. it is the simplest of all. set the date cells not as custom mmm-yy Set as text and then input the dates manually.


Then the formula works. NO more manually formulas just simple copy and paste. many thanks.