Ignoring category in combochart to show straight line

[sabmaldun]

Hello,

I would like to create just a straight reference line according to this Expression in a combochart:

(SUM({<Year={"$(=MAX(Year))"},Month={"<=$(=MAX(Month))"}>}TOTAL <Category>PartSales)/SUM({<Year={"$(=MAX(Year))"},Month={"<=$(=MAX(Month))"}>} TOTAL <Category>Throughputs))

The Barchart of the combochart has "Category" as Dimensions and I want to ignore this Dimension to Show a straight line of the value which results of the Formula.

I tried with total qualifier as I read in another thread, but it did not work for me.

Anyone has a Suggestion, how to solve the Problem?

Either ignore Dimension or convert the Formula into a fixed numbervalue?

Thank you,

Regards Jonas

[sunny_talwar · Accepted solution]

Did this not work?

Sum({<Year = {"$(=Max(Year))"}, Month = {"<=$(=Max(Month))"}>} TOTAL PartSales)/
Sum({<Year = {"$(=Max(Year))"}, Month = {"<=$(=Max(Month))"}>} TOTAL Throughputs)

[sabmaldun]

This worked.

Thank you, 😃