Unique Values Sum

I have a field named targetestimated representing values for all programs within each Program Increment (PI). For each program, the numbers can be the same or different. I need to calculate the sum of unique numbers for each PI and Program in Amazon QuickSight. How can I achieve this?"
Screenshot 2023-11-28 180706

Hi @hellosai321,

Can you try this?
sum(min(EstimatedTarget, [PI, Program, EstimatedTarget]))

2 Likes