Forum Discussion
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")
In this situation, I'd use cell addresses instead of GETPIVOTDATA.
HansVogelaar thank you that helped
