table / chart issue QV v8.5

[#1]

Hi All,

Have an issue where 2 subtotals in the same table are behaving differently to the rest of the subtotals, and don't know why?

Have amended first thoughts to enable sub-totals to appear, but they don't look correct, nor do they appear in the charts?

Have attached an example file

Any ideas greatly appreciated!

Kind regards,

Rich

(also please let me know if the values are being displayed in your version (if different to v8.5)

[#2]

Hi Matt / All,

Am trying to apply the "Aggr" function to overcome similar problems found in earlier example.

This formula is only a little more complex than the past, although am unsure where exactly the " aggr((( " " ),Material) " ought to be placed in this example:

The below formula returns data as it should in a table, now need to modify it so that its "Graph" friendly...

______________________________________

if(sum({$<Year = {$(=min(Year))}>} QtyKG)=0

or

sum({$<Year = {$(=max(Year))}>} QtyKG)=0

,0

,

(sum({$<Year = {$(=max(Year))}>} QtyKG/1000)
-
sum({$<Year = {$(=min(Year))}>} QtyKG/1000))
*
sum({$<Year = {$(=max(Year))}>} Euros/1000)/sum({$<Year = {$(=max(Year))}>} QtyKG/1000)

___________________________________

Initial thoughts were to only have one "sum(Aggr((...." & " ....),Material)) " at the begining or the end, but did not give the desired results.

Tried putting these statements after the "IF" statement, and wasn't seeing what I hoped to

Also tried adding "Aggr((" & "),Material))" in each of the formulae that orginal just had a "sum("

Anyone with any thoughts?

Kind regards,

Rich

[#3]

please ignore the above, I was missing a ")". Solution works fine with the "sum(Agg(( " & "),Materials))