Get Subtotal from Pivot with Sumifs with out repeat all

Hi All,

Hope all out here and their loved ones are doing good !!

The problem I have is to get a subtotal using sumifs(preferred no VBA please) from Pivot data set without repeating all.

So basically while doing sumifs it should pick up the last non empty cell and do the sumifs.

Attached is the example file for better understanding.

Hi,
You can repeat item labels by right clicking on the "Name" title ---> Field settings---> 'Layout and print' tab--->'repeat item labels

Your Sumif will work then correctly.

This needs to be without repeat all.