Forum Discussion
Solved
Get Pivot Data
Hello all, i'd like your help about get pivot data from pivot model. i keep getting #reff results. so in this case i'd like to show map chart with each region that been set. the formula...
In the empty cell you may start typing = when click on cell within PivotTable, e.g. on H38, Enter, it returns correct formula which you may adjust with parameters. Before that check if this setting is ON
I guess it shall be not "PROVINCE" but something like "[MyTable].[Province]", etc.
Thank you so much for your feedback, and it works!
as you said, at the last formula it must field;item so i rewrite it to:
=GETPIVOTDATA("[Measures].[Average of Diff Value (%)]";pivot_table;"[Table7].[PROVINCE]";"[Table7].[PROVINCE].&[JAKARTA]")
after that i rewrite the province name for each field;item per row and the map chart works fine
Good to know it helped, thank you for the feedback