How To Apply Data Filter On Pivot Table Columns!

Dear Friends,

Please find an attached Excel Sheet, there are two worksheets!

Raw Data Sheet: -

Column A: F Contains Product, Planner, Group, Sub_Group and Qty Per Details respectively!

Pivot Sheet: -

1. Column H:S is a Pivot table of above “Raw Data Sheet”. And Week on Week Rawdata will keep added one below other, simultaneously Pivot table also will get extended from Column H:S to H:Many Column!

2. In the Same sheet Column A:F I have few basic calculations which I derive from right hand side Pivot Table

Support Required is: -

I should be able to apply Filter on Row Number 5 (Starting from Column A to the extent Pivot table availability) in “Pivot Sheet”

Is there any inbuilt option which helps me to apply “Data Filter” On Pivot Table (Entire Row 5), Else please suggest me a VBA Code which meets my subjected requirement!

Looking Forward your valuable suggestions!

Thanks & Regards,
Rajeshkumar R

in the pivot,
you can place a field in the FILTERS box, then filter 1 or more items in that field.

Dear ranman256,

Thanks for your Response, above suggestion might not suit my requirement!

Because, Example : I want to Apply Filter on Row 5 then I want to Filter on Column M with >0 Value. With the filtered view I should be able to view all other products and calculation as well!

Thanks & Regards,
Rajeshkumar R

Dear Experts,

Any better Suggestion on my subjected Query Please?

Thanks & Regards,
Rajeshkumar R