chart and table not showing same data

[#1]

Hi,

  I created one table and one chart for sum. but table is showing correct figures but chart's sum is not showing same as table sum. for table sum, I took export to excel and made sum. both are not same.

Reason ?

Thanks

Amit

[mohammadkhatimi]

See the below screenshot..the UID 2372 for 1/1/2015, the sum of table box is 194841.6957 and in Pivot Chart it is 389683.391412, this differ because each number is repeated twice as you can see in the list box with frequency of 2. So in the Chart is showing the sum of all nos twice and table box is showing the distinct values sum.

Hope it helps you!!!

Regards,

Mohammad

[#3]

Hi,

You are correct. How will I remove duplicates from chart calculation as I need to use chart only.

[mohammadkhatimi]

what do u mean to say u want sum as table Box or Chart??

[#5]

as chart .

[mohammadkhatimi]

I asked u about the sum..can u please explain me clearly

[#7]

I want sum(epmplannedcost) in chart to be same as table box sum.

Table box sum is correct in reality. So chart's sum should also give same.

[marcus_sommer]

The chart-calculation itself is correct and also shows the tablebox correct data. Removing from data maybe per distinct while the loads migt lead to incorrect results. I think you need at first to understand your data-source better before goes further. The above mentioned blog-posting to counters within the load is very helpful to understand the data-sources.

- Marcus

[mohammadkhatimi · Accepted solution]

Try This..

=sum(aggr(sum(distinct EPMPlannedCost),UID,BillingDate))

Regards,

Mohammad

[#10]

Hi,

I checked from data source and sum from table object is coming correct but not from chart object

[mohammadkhatimi]

Have u check diz....it will work...

Try This..

=sum(aggr(sum(distinct EPMPlannedCost),UID,BillingDate))

Regards,

Mohammad