Bar chart with values from two tables, one of them presented as a histogram

[#1]

I have a table with business transactions (sales orders) containing a material# (containing many transactions for one material#). I want a bar chart with the material# on the x axis (sorted according the frequency of occurrence, descending) and the number of transactions with this particular material# on y. This is the easy part and it works fine.

transaction# Material#

1 4711

2 4711

3 4711

4 4712

Now I want to add the stock level for each material#. This stock value comes from a different table which only has the two fields material# and value.

material# value

4711 115 CHF

4712 300 CHF

The result should be:

material# value frequency

4711 115 CHF 3

4712 300 CHF 1

This shows, were your stocks are, with the fast or with the slow moving materials.

regards

andreas

[Anonymous]

If you load both tables, they should be connected on the field "Material#", right?

If that is the case you could use something like below in your expression:

Count(Distinct transaction#)

This should return

4711 3
4712 1

Is this what you are looking for?

[#3]

You are right. If I load both tables with the same field name for Material# they are somehow connected. Now I want a diagram with material# as the x-axis and the two values (value and frequency) on the Y-axis. This works by using a split axis. Very cool.

Thank you very much!