Pivot table error

[umairarshad]

Hello,

I am sorry if i selected the wrong section.

I am working on a pivot table. When I drag it, the value did not change.

Please see screenshoot below

Please tell how to fix it?

[ryan_mayu]

@umairarshad 

The month in formula is always "Apr". You should change it to the cell name. 

[umairarshad]

I tried it but got the following error.

What to do?

[umairarshad]

Let me try. Will let you know.

[ryan_mayu]

@umairarshad 

pls try something like below

=GETPIVOTDATA("[Measures].[downtimecount]",$B$3,"[Table5].[Station]","[Table5].[Station].&[ISB]","[Table5].[Month]","[Table5].[Month].&["&P19&"]")

[umairarshad]

I am unable to do.

Can you please correct? I am pasting the formula.

=GETPIVOTDATA("[Measures].[Count of Downtime]",$O$18,"[Downtime].[Station]","[Downtime].[Station].&[ISB]","[MTBF Available Time].[Month]","[MTBF Available Time].[Month].&[Apr]")

[ryan_mayu]

pls try this

=GETPIVOTDATA("[Measures].[Count of Downtime]",$O$18,"[Downtime].[Station]","[Downtime].[Station].&[ISB]","[MTBF Available Time].[Month]","[MTBF Available Time].[Month].&["&P19&"]")