Forum Discussion
Pivot table error
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?
The month in formula is always "Apr". You should change it to the cell name.
Let me try. Will let you know.
pls try something like below
=GETPIVOTDATA("[Measures].[downtimecount]",$B$3,"[Table5].[Station]","[Table5].[Station].&[ISB]","[Table5].[Month]","[Table5].[Month].&["&P19&"]")
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]")
I tried it but got the following error.
What to do?
