question on displaying a pivot cell value in a text box

[gerrycastellino]

Is there a simple way to get the value of a cell in a pivot chart to display in a text box ?

Gerry

[Anonymous · Accepted solution]

Unfortunately, there is no way you can address a cell in a pivot table to retrieve its value (at least not that I'm aware of). But, if you know the dimension values in question, you could use them in a set analysis expression to "address the cell". Let's assume the pivot table has the dimensions Client and Year, and the expression Sum(Sales). And you want the cell for ClientA and year 2013. In your text box, you would use this expression:

Sum({$<Client = {'ClienteA'}, Year = {2013}>} Sales)

Hope it helps.

Cheers,

- Bruno.