Totals in Table is correct, but not in KPI

[Anonymous]

Hi,
I am having issue with total sale price for a KPI.

The table is showing the correct total if I set Totals Function to "Sum"

When I set the Totals function to Auto I get the same results as the KPI calculation.

I need to show the total sales in KPI.

Thanks for the help!

[hacr]

I found following in the forum, and as expected, the evaluation is different. It would be a help to see the data used for the example giving the "wrong" KPI

Auto means calculate the total by evaluating the expression over all data.  Sum means to sum up the rows in the chart. There can be differences depending on your data model and dimensions used.  For example, Auto will never double count. Sum can double count when for example the same fact is connected to more than one dimension in the chart.

[Anil_Babu_Samineni]

Can you please share application to test

[Anonymous]

I'm trying to have in KPI, so I don't know how to set the formula .

[Anonymous]

Please find attached test qvf

[Anonymous]

Do you guys have any solutions? Thanks.

[timpoismans]

Is this what you had in mind:

Measure used is:

Sum(Aggr(Sum(Price)*Sum(Sales),[item #]))

[Anonymous]

That's what I wanted. I'll test it and let you know. Thanks for the help.