Aggr qlik sense

[Yuly]

Good afternoon.

Please help.

At me at aggregation of the data the total sum incorrectly beats.

Formula :

sum(aggr
(sum(aggr(SUM(REV0_23M1),CALL_MONTH, GLOBAL_REGION, SEGMENT_,TSPK, FIO, OPERATOR_EPML))
/sum(aggr(SUM(RT0M_23M1),CALL_MONTH, GLOBAL_REGION, SEGMENT_, TSPK, FIO, OPERATOR_EPML))

* sum(CONNECTED),CALL_MONTH, GLOBAL_REGION, SEGMENT_,TSPK, FIO, OPERATOR_EPML))

* (
Sum(RT0M_23M1) +
Sum(RT0M_23M2)+
Sum(RT0M_23M3)
)
/
(
Sum(RT_M1)+
Sum(RT_M2)+
Sum(RT_M3)
)

 

In the context of the employee, the amount is correct, but the total amount is not

[cristianj23a]

Hello.
To customize your totals, use the "Dimensionality()" command.

Here is a link that explains what it is about and how you can use it.

https://help.qlik.com/en-US/sense/May2023/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/InterRecor...

https://www.youtube.com/watch?v=uzXHbhNCykM

Regarts.