Totaling issue

[priyanka08]

Hi,

I am facing an issue that 1 region have 2 code 2 id and 2 type but in total i want to show the total with respective region that is 16000 instead of 32000

[Vegar]

Is this your source data, or is this the output after you have done your script and data modelling in Qlik Sense? 

In your sample all the region XX values are 8000, how do you want to handle the total if there where to be four different values? Is it the average of the four or do you have any other criteria?

[priyanka08]

column B to Column E is coming from source  system. and column A is coming from other table where Region is mapped on the code .In actual code is basically customer code and region is customer parent and one customer parent could have multiple customer code