sabmaldun
Contributor II
2019-02-25
04:23 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
987 Views
1 Solution
Accepted Solutions
sunny_talwar
MVP
2019-02-25
07:37 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Did this not work?
Sum({<Year = {"$(=Max(Year))"}, Month = {"<=$(=Max(Month))"}>} TOTAL PartSales)/ Sum({<Year = {"$(=Max(Year))"}, Month = {"<=$(=Max(Month))"}>} TOTAL Throughputs)
2 Replies
sunny_talwar
MVP
2019-02-25
07:37 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Did this not work?
Sum({<Year = {"$(=Max(Year))"}, Month = {"<=$(=Max(Month))"}>} TOTAL PartSales)/ Sum({<Year = {"$(=Max(Year))"}, Month = {"<=$(=Max(Month))"}>} TOTAL Throughputs)
sabmaldun
Contributor II
2019-02-26
09:46 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This worked.
Thank you, 😃
960 Views