Excel

New Contributor

Good day

Trust you are well

May you please assist, after i have made a pivot table on my excel and when i  sum up column B2: C3  and drag down its no carrying down the formula.I have to sum up each column separately. What formula do i use so i can drag down the answer. I remember we used to insert a D somewhere but i cant remember where. please assist?

=GETPIVOTDATA("Sum of Overdue + Due ";$A$4;"Legal Status ";"Domestic")+GETPIVOTDATA("Sum of Less Risk amount ";$A$4;"Legal Status ";"Domestic") 

Enalla75_0-1659635223846.png

 

2 Replies

@Enalla75 

In this situation, I'd use cell addresses instead of GETPIVOTDATA.

@Hans Vogelaar thank you that helped