Aggregate based on dimensions

[selvakumarsr]

Hi All,

Is there an way to sum based on dimension.

For example (Data Source):

Date	Employee	PurchaseOrder	Vendor	Days
1-Jan-17	Emp1	P0001	V0001	1
1-Jan-17	Emp1	P0002	V0001	1
1-Jan-17	Emp1	P0002	V0002	1

If it vendor,date and employee is same then the days count is 1 in my output

Expected Output:

Date	Employee	PurchaseOrder	Vendor	Total Days
1-Jan-17	Emp1	P0001	V0001	1
1-Jan-17	Emp1	P0002	V0001
1-Jan-17	Emp1	P0002	V0002	1

Thanks,

Selva

[sunny_talwar · Accepted solution]

May be this:

Aggr(Count(DISTINCT Date&Vendor&Employee), Date, Vendor, Employee)