How to Write it in data load editor

[Noobforever]

Hi team I am doing a transformation in the front end chart, which I want to shift it to the backend(data load editor)

because its taking a lot of time to load the chart

My equation is : Sum( Aggr (Count ( Distinct [Customer Number]),Categories))

How do i write this in the data load editor.

The solution I am using but not getting the correct output: 

Customer:

LOAD Distinct

Count([Customer Number]) as "Customer Number"

from table;

and using Sum(Customer Number) in the chart

[BrunPierre]

Something like this

LOAD Categories,
Count(DISTINCT "Customer Number") as "Customer Number"

Resident MainTable
Group By Categories;

DROP Table MainTable;