PDA

View Full Version : [SOLVED] Code for Pivot



Veeru
04-18-2018, 11:19 PM
HI,

Looking for a code which select name of customer in Pivot table from Cret tab in attaced sheet.

Thanks in advance

Paul_Hossler
04-19-2018, 07:06 AM
Since you don't have customer name as a field in the pivot table, I think you'll need to go back to the data

Put this inB2 of Cret and see



=SUMIF(Data!$A:$A,Cret!$A$2,Data!$C:$C)