Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this:
Aggr(Count(DISTINCT Date&Vendor&Employee), Date, Vendor, Employee)
May be this:
Aggr(Count(DISTINCT Date&Vendor&Employee), Date, Vendor, Employee)