Sum by fields

[#1]

Hi community,

I figure I try to explain the issue I have with a picture to see if anyone could find a solution.

In the pic you see 2 tables from different sources, ideal they would both show same amount of rows and same total turnover.

Is it possible to sum by values so sume turonver for Price, Side and SD?

So in the right table e.g. would be grouped into 1 row.

Also attached an example app

[Gysbert_Wassenaar]

Yes, remove all the columns that make the row unique. In other words keep only the columns that have the same value on every row: eod_MIC, eod_SD, eod_Side, eod_S... and eod_TD.

[MK_QSL]

Your question is not clear.. provide sample data or sample app to understand better.

[#4]

Yeah I understand that option is available but Price is quantitity is still highly important but the sum sohuld not be based upon it. If you understand wha tI mean :S

[Gysbert_Wassenaar]

Sorry, I have no idea what you're talking about.

So in the right table e.g. would be grouped into 1 row.

That's possible if do as I explained above. Use only the dimensions that have the same value for every row. Use aggregation functions like sum to calculate whatever you think you need using the measure fields.