Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
Can you please share application to test
I'm trying to have in KPI, so I don't know how to set the formula .
Please find attached test qvf
Is this what you had in mind:
Measure used is:
Sum(Aggr(Sum(Price)*Sum(Sales),[item #]))