Get cell value from a pivot table using rowno() and columnno() - in chart expressions

[sarathi_pm]

Hi,

I have a pivot table. I want to get the cell value of the pivot table using rowno() and columnno() in chart expression.

I am trying to get the totals from the pivot chart based on the rowno and column no.

Is this possible?

Thanks

Sarathi

[Gysbert_Wassenaar]

No, that's not possible. If you want to show totals in the pivot table you can enable the Partial Sums option for the dimension on the Presentation tab. If you want to show the totals of the pivot table in another object you'll have to use the same expression you used in the pivot chart (and perhaps add some of the dimensions if you want the subtotals of dimensions).