Group by two dimensions

[Anonymous]

Good day.

There is my model in attached file.

In load script i calculate max date, where quantity > 0 grouping by Spoits.

How can i calculate the same, but grouping by Spoints and ProductType?

Thank you!

[PradeepReddy · Accepted solution]

Use the both the dimensions in group statement..

ex:

Group By Spoint,ProductType;

[its_anandrjs]

Then write like

Join

Load

  Spoint,

  ProductType,

  Date(Max(Date))

Resident Input Where Quantity>0 Group By Spoint,ProductType;

[avinashelite]

Hi,

Please find the attachment for the solution.