Query on pivot table total

[#1]

Dear,

Having a pivot table As the attached image, which includes a column of "Totals", there is the possibility of creating a UN "Text object" in sheet Y That said "Text object" represents the total of Said table In this case "26".

The idea is to be able to add in that "Text Object" number that "26" another air total of another pivot table.

Waiting A good welcome,

Say hello.

Eduardo

[Frank_Hartmann]

Not sure if i understood you correctly, but if you want to show the Total in a

textbox please have a look at the attached sample

[#3]

Dear Frank

Thank you very much for the example, unfortunately I could only solve part of the problem.

What I want to do in is the following (The results that are in red color, is what I want to place in a "Text Object"):

[Frank_Hartmann · Accepted solution]

see attached qvw

hope this helps

[neha_shirsath]

Why you want to put red numbers in Text object ? because if you make any selection in Pivot then size of chart will vary and this text object place will be fixed. Might be i'm not getting your question.