New Contributor

# Excel

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")

2 Replies