I wanted to create a pivot table and a KPI visual on the dashboard. The idea is to sum the revenue of distinct customers. The data is not at the customer level but breaking down to month, product, etc.
The Revenue columns shows the revenue of each customer.
The expected output is to show 8.06M which is the sum of Customer C and Customer D with Customer C only being counted once.
