UNABLE TO AGGREGATE TO DISTRICT LEVEL

I am using DHIS2 2.26.I developed an aggregate tool whose lowest level of data entry is the Health Facility.

I run analytics but when i run Pivot tables,the results is a blank table at other levels but when i select at health facility level the data is present.

Where could i have gone wrong?

Thanks

Stanley