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?
6 Replies
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 tried it but got the following error.
What to do?
