Originally Posted by vlady hello can you try.. margin =IFERROR(SUM(GETPIVOTDATA("$ GM",$A$3,"Item Description",$A$5),GETPIVOTDATA("$ GM",$A$3,"Item Description",A5)),"") I have tried this thanks (see attached) yet it is not giving me the correct numbers in the GM column?????????
=IFERROR(SUM(GETPIVOTDATA("$ GM",$A$3,"Item Description",$A$5),GETPIVOTDATA("$ GM",$A$3,"Item Description",A5)),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Forum Rules
Bookmarks