Hi,
I have the Billing Document in the Projection (in my HANA Calculation View) with following records:
screenshot-2023-09-13-101750.png
How can I create the Distinct Count of Location grouped by Area.
In above example:
1. the Distinct Count of Location for Area A1 is 1.
2. the Distinct Count of Location for Area A2 is 2.
3. the Distinct Count of Location for Area A3 is 1.
In the Aggregation Node, I tried create the Count for this using Column Area and Location but doesn't seem working.
Any suggestion?
Thanks in advance.