CODEWITHSUNDEEP
excelexcel-formulapowerquerypowerpivot
Stuck At Home Overflow
Stuck At Home Overflow

Reputation: 61

Copy Pivot Table Values and Format on another cell

How do I copy and paste a value in a pivot table and also at the same time copying its format if combined with text. There will be like multiple concatenations on the destination cell.

I cannot seem to make it work (cell A7 is my try).

Please see below.

enter image description here

Upvotes: 0

Views: 611

Answers (2)

AnilGoyal
AnilGoyal

Reputation: 26218

Use this

=Round(GETPIVOTDATA("[Measures].[Sum of Sales Value in Euro]",$A$3)/1000,1)&"K Eur ("&Round(GETPIVOTDATA("[Measures].[Sum of Value % Chg YA]",$A$3),2)&"%)"

Upvotes: 0

P.b
P.b

Reputation: 11415

I can't think of an answer to referring to formatting of a cell without using vba, but indirectly you might get the desired result by using the camera tool/linked picture referring to the cell(s) you need. This will exactly show what and how you want it. Not sure if that's something you desire to work with.

Upvotes: 1

Related Questions