Configured the action flow to send an email where it would summarise at the top the total amounts and below it will be the details in a table format. The table format displays everything correctly, however the sum at the top omits when the table has duplicate values and so is incorrect.
just to throw ideas... maybe the sum of the top is a sum of distinct values? Then it will make sense that if finding a duplicate it will not add the amount....
Just my 0,02 €
Hmmmm
if you do the same using a single KPI for the aggregate, and a OLAP Table as the table details...
...what behaviour do you get?
Maybe it's the queries you are doing... just (again) throwing out ideas....
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.