Forum Discussion
Solved
Fetch specific cell value which matches the RowName and ColumnName
Is it possible to create a "Excel formula" where it returns the value of the cell (or) row number and column number when it matches with the specific row name and column name. For example:I need ...
suthandira , for such sample
it'll be
=GETPIVOTDATA("[Measures].[Sum of C]",$F$5,"[Table1].[A]","[Table1].[A].&[MRO2]","[Table1].[B]","[Table1].[B].&[AMS]")The easiest way to generate the formula - type "=" in any empty cell and click on proper cell within your PivotTable. After that you may play with adjustments.
Thank you soo much for helping me :)
suthandira you are welcome