Getpivotdata using "SUMIFS" FORMULA for Stock management.

[krunal123]

=GETPIVOTDATA(SUMIFS(B4:B5,A4,"")-SUMIFS(C4:C5,A4,""))

I was trying Get data from pivot table, kindly Help to correction Formula... i was trying (PURCHESH NET WT-SALE NET WT) and getting Result...

Get pivot data using "SUMIFS" FORMULA for Stock management.

HELP !!! HELP !!! HELP !!! HELP !!! HELP !!! HELP !!! HELP !!! HELP !!! HELP !!! HELP !!!

 

[GraH]

Getpivotdata returns any pivot calculates field by refering to the coordinated fields, row and column wise.
So you can't combine with SUMIFS. Why do you try this?

 

[krunal123]

View attachment 71501

=GETPIVOTDATA(SUMIFS(B4:B5,A4,"")-SUMIFS(C4:C5,A4,""))

I was trying Get data from pivot table, kindly Help to correction Formula... i was trying (PURCHESH NET WT-SALE NET WT) and getting Result...

Get pivot data using "SUMIFS" FORMULA for Stock management.

HELP !!! HELP !!! HELP !!! HELP !!! HELP !!! HELP !!! HELP !!! HELP !!! HELP !!! HELP !!!

i was Try closing balance , data Show on Dashboard Sheet