How to Sum Revenue of Distinct Customers?

Q&A
,
1

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.

image
image1339Ă—247 9.74 KB

2

Try using sumOver with PRE_AGG

3

Hi @grac,

Just checking back in since we haven’t heard from you in a bit. Were you able to see Hrolol’s reply and/or find a solution yourself in the meantime? If you still have any additional questions related to your initial post, please feel free to share them. Otherwise, any update you’re able to provide within the next 3 business days would be helpful for the community.

Thanks!

4

Hi @grac,

Since we haven’t received any further updates from you, I’ll treat this inquiry as complete for now. If you have any additional questions, feel free to create a new post in the community and link this discussion for context.

Thanks!