look up field with pivot function in zoho

Hello

I need some experts for help me to make the below function workable

Sourcing view

Form Pivot

Here you can see all the fields are look up fields from sourcing view,function I would like to set up is same as exel pivot table, for example while user select specific data in Region, country fields only pop up data under this selected region.

I’v tried many times with different solutions, still doesn’t work. Please help

Many thanks
Priscilla