We are attempting to retrieve the value of the "SKU" (circled - red) row/cell. We can get the cell value from the column Sales$ (circled - yellow) but the same method does not seem to work for the row values.
Can you please provide us with some direction on this?
Thank you.
Thank you for the reply. We understand these are two different areas! What we need to know is what method we should be using to get the values from the "row headers".
Just to clarify - we are using WinPivotGrid.
Hello Paul,
In the above PivotGrid, the values circled in yellow and red belong to two different data areas. The value highlighted in yellow is from cell values of measures that are queried for and the one highlighted in red is from the Rows/Columns header cell values. Both values cannot be accessed using the same method.
You would have to look into the row headers in order to access the value circled in red.
Please let me know if I may be of further assistance.