SUM TOTAL and AVG

[#1]

Dear all,

I need a solution for my problem. I want to use the totals of the tables below for further calculations.

There must be a solution, but I couldn't find it. I tried AGGR, sum(total <field>), but without result.

Order 960 has 5 codes of 30 and order 961 has 1 code of 30.

I need the following figures:

- Total Orderbedrag = 180

- Avg Orderbedrag = 90

- Avg Bonbedrag = 30

Can you help me with this?

Kind regards,

Erwin

[MK_QSL]

On what basis both tables are linked with each other?

[#3]

I've attached screenshot

[MK_QSL]

But you haven't provided proper sample data files !

[#5]

Manish Kachhia schreef:

Just give us few lines in excel...

I created a few lines in excel, just like you asked...

This should be enough for the problem, right?

Kind regards, Erwin

[MK_QSL]

I don't find any common field in your excel files which can link these two tables...

[qlikpahadi07]

Hi Erwin,

I have gone through the thread but it is not clear what exactly your issue is.

You have to create dummy data or export properly with out put you need.

as you mentioned "Order 960 has 5 codes of 30 and order 961 has 1 code of 30." it seems you can create this dummy data in Excel with 3 tabs as tables with output you needed.

cheers!!!

[#8]

I uploaded a new file with the connecting ID.

[MK_QSL]

Like this?

[#10]

Sorry I cannot open this document, because I am on personal license...

[MK_QSL]

Create a Straight Table

Dimension = Orderid

Expressions

SUM(Amount)

SUM([Order Amount])

SUM(TOTAL<OrderId> [Order Amount])

SUM(TOTAL <CodeId,OrderId>[Order Amount])/COUNT(OrderId)

COUNT(CodeId)

AVG(Amount)