Dimensions values Adds up

[vardhan1305]

I have a situation where the Dimension values are adding up instead of showing the individual value.

Value1 and Value 2 are the dimensions and  when selected multiple ID's the  Field values are adding up and it's populating the Sum value

O/P which i got:

ID              Customer          Value1     Value2 

1001              ABC                35               110

1002              xyz                  35                110

Instead of

Actual O/P:

ID              Customer          Value1            Value2

1001              ABC                15                    90

1002              xyz                  20                    20

Please Help me out.

[MindaugasBacius]

Try to aggregate in backend:

tmp:

load ID

,Customer

,Sum(Value1) as Sum_Value1

,Sum(Value2) as Sum_Value2

resident Sales

Group by ID, Customer;

[vardhan1305]

Its not possible to do in backend as it has many records.. is there any way to do it in front end.

[MindaugasBacius]

Sure. Just update your expressions as following:

Sum(TOTAL Value1)

Sum(TOTAL Value2)

[uacg0009]

Hi harsha,

could you please give a sample of your qvw, so I can see your table and dimension and expressions to try to find out what the problem is.

Aiolos

[shreya_nadkarni]

try the aggr() in frontend

[Jesh19]

what is the expression that you're using.

Can you please share some sample data.