Dicrepancy in Total of Pivot table

[saniyask]

Hi,

I have a chart where the Sum of values(non zeros) or sum of line items is 200 whereas i am getting the total sum as 210, how shall i rectify or trouble shoot this issue??

Note:-- It is a Pivot table ,there are no filters or selections or triggers applied on the chart and the value of the expression in text box also evaluates to 250 and not 200.

I am attaching an excel file for your better understanding.(Data of the entire chart is copied to the table)

Regards,

Saniya

[marcus_sommer]

Try something like this as chart-expression:

sum(aggr(YourExpression, Employee, Date))

- Marcus

[saniyask]

Hi Marcus,

I have tried aggr function its not working for this error.

Regards,

Saniya

[sunny_talwar]

Would you be able to share a sample where Aggr() isn't working as Marcus prescribed?

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample

[saniyask]

Hi,

Sorry for the delay in response.

I have one single dimension and I am using the expression as if(Sum(Sales)>0,Count(Distinct Customer)) this gives me the correct data as per the line items i.e (386) but the total comes to (457).

Wont be able to attach the application hence attaching the dump of the report in excel, I am really confused and would really appreciate if you could help me out with this.

Regards,

Saniya.

[Anil_Babu_Samineni]

Here, It showing 386 only. Might they entered manually i've tested this =SUM(C2:C387)

Check your attachment.

[sunny_talwar · Accepted solution]

What is the name of your dimension? I think all you need is to do this

Sum(Aggr(If(Sum(Sales) > 0, Count(DISTINCT Customer)), DimesnionName))

Replace DimensionName with the name of the dimension you have in your table....