problem with aggregation

[danyferde]

Good afternoon everybody,

I'm new here in this word (1 Month) and I'm having some issues on aggregation functions on pivot tables and plan tables

Here below I have part of a table with totalization for BUDGET ANNUALE (annual budget) and other 2 fields.

The real annual budget sum must be 5100, but for a double field calculation is 5700(5100 +600). 

How is it possible to aggregate the fields CentroCosto (maybe in sum calculation?) to have only 1 time calculation of annual budget for each Code&Title?

Thanks a lot to everybody

[dplr-rn]

try total qualifier
e.g. TOTAL<CentroCosto >

https://community.qlik.com/t5/Qlik-Design-Blog/What-does-the-TOTAL-qualifier-do/ba-p/1472990

[Channa]

remove this column"numero_po"

it is because of your datamodel

[danyferde]

HI Channa

first of all thank you so much for your answer.

I don't have good news about, I already tried to exclude one by one all the field in report, but totalization never change.

Mainly the problem is that the ANNUAL BUDGET must remain the same for every single code, but every single code has lot of "sublines" , the totalization of these sublines (Purchase Order) is ok to calculate total PO expenses, but is wrong for Annual Budget because I need only the value allocated for that year.

To have the relation from budget to purchaseOrder my only way is to relate using that Budgetcode, relational databasese obviously report the value ANNULA BUDGET for each record summing the totals.

is there the possibility to have a sum grouped for... or some function procedure to consider only 1 value for each BudgetCode?

I hope to have explained better my situation (it's not easy)

Thanks a lot

RGDS

[Channa · Accepted solution]

You can use AGGR function to get sum of value group by dimension

Aggr(sum(value), dimension)