How to get specific cell values from pivot table

[gf]

Hello everyone!

I would like to display specific cell values from a pivot table into a text box.

The cell values are dynamic because you can change the language. 

Is there a function/expression like Cells(1,1).Value or something like that?

Thanks in advance!

[jyothish8807]

Hi Gf,

Not exactly like cell function, but you can use set analysis to get the specific value.

For eg, you want to show the sales of Prodct "A" for month "Feb" in a text box, which is also available in pivot, then write like this in text box:

Sum({<Product ={'A'},Month={'Feb'}>}Sales)

If you can share your exact requirement with some sample data or screenshot, then it will be easy to help you.

[gf]

Thanks for your reply KC!
I'm sorry I'm not allowed to upload the file but i can provide a picture.
Column "1" to "Kontobezeichnung" are dimensions and i need for example the cell value from column 1, row 1. => "A K T I V A"

[jyothish8807]

Hi Gf,

Since it is a dimension, iam sure there will be a filed you are using in the pivot chart.

So in a text box simply write:

If(YourfieldName='AKTIVA',YourfieldName)

[gf]

But the value AKTIVA can change, for example in english it is written with "C" instead of "K". That's why i want a solution where i don't have to type in "AKTIVA" hard coded. Therefore i need something like Cell(1,1).Value or Top() or Above().....

[jyothish8807]

Hi Gf,

You can try this:

=subfield(Concat(YourField,','),',',1)

[gf]

Hello KC!

Thanks for the answer! It partly works.

If i type =subfield(Concat(TextG1,','),',',1) i get A K T I V A as expected, but when i try it with =subfield(Concat(TextG1,','),',',2)

I also get A K T I V A. 

I thought =subfield(Concat(TextG1,','),',',2) gives my the value from column 1 (=TextG1) cell 2?

[jyothish8807 · Accepted solution]

Try this:

subfield(Concat(distinct TextG1,','),',',2)

[gf]

Perfect! Thank you very much!
Thank you for your time and consideration!

[jyothish8807]

You are welcome