Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Is Sequence the same thing as Established Products and Team is same thing as Local_BU?
A comments: The total in a chart is not (and should not be) the sum of rows. See more on
HIC