Chart with sum

[danosoft]

Hi i have the situation in the picture.

I want to show in the round chart the number of Sum of my Items i have 2 tables (the one table show only DataStart but i have a column named Items; the second table show the DataFinish with column Items)

how can i show in chart the difference from count of items from table 2 and table 1?

like: count(items table2) - count(items table1)

thanks

[pradosh_thakur · Accepted solution]

May be

in the script

add an extra column

Item as Item1 in table 1

Item as Item2 in table 2

then count(item1)-count(item2)

regards

Pradosh

[danosoft]

but if i choose a DateStart in table 1 i want the chart refresh it with  count(items table2) - count(items table1) for the date i choose, the same thing if i choose DateFinish in table2

[pradosh_thakur]

It shall change as it will be associated i guess. did you give a try ?

regards

Pradosh