Total Miss Matching In Pivot Table

dineshm030 · ‎2017-09-21

Hi All,

Emergency!!!!

I created the report with pivot table by 4 dimensions. The total is mismatching in that report. Can you pls give the solution?

The original total is 1101547 but 1043921 is coming.

My Expression:

If(My Expression(Sales_Value))

If I am using AGGR condition, some values is not coming.

From the team, ONCOLOGY and RARE DISEASE is going to some other teams.

My Expression:

Sum(Aggr(If(My Expression(Sales_Value))),Group,Established Products,Local_BU))

Thanks in advance.

sunny_talwar · ‎2017-09-21

Is Sequence the same thing as Established Products and Team is same thing as Local_BU?

hic · ‎2017-09-21

A comments: The total in a chart is not (and should not be) the sum of rows. See more on

HIC