Hello to all from Amit Desai

Hi,

need help on excel data.

Hi,

i have data in sheet Raw Data. i have created pivot in "Validation data" for category and sub category. in the sheet "Yrl-Cat" i have used sumifs formula based on category and sub category. i want to filter a data such a way that when i select category in A5 cell of "Yrl-Cat" in the table sub category should get filter and shows only those sub category that belongs to the category selected in cell A5.
to understand the requirement i have created one example file which is attached here with.
can someone help me to fulfill my requirements.

Regards,
Amit Desai.