Announcements
cancel
Showing results for
Did you mean:
Contributor II

## Ignoring category in combochart to show straight line

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

1 Solution

Accepted Solutions
MVP

Did this not work?

```Sum({<Year = {"\$(=Max(Year))"}, Month = {"<=\$(=Max(Month))"}>} TOTAL PartSales)/
Sum({<Year = {"\$(=Max(Year))"}, Month = {"<=\$(=Max(Month))"}>} TOTAL Throughputs)```
2 Replies
MVP

Did this not work?

```Sum({<Year = {"\$(=Max(Year))"}, Month = {"<=\$(=Max(Month))"}>} TOTAL PartSales)/
Sum({<Year = {"\$(=Max(Year))"}, Month = {"<=\$(=Max(Month))"}>} TOTAL Throughputs)```
Contributor II
Author

This worked.

Thank you, 😃