Set Analysis in Chart Dimension

[embruqlikview]

I need a chart, that use all years in my data, unless a selected year.

Can i use a Set Analysis as Chart Dimension overriding selected years?

In example above, i have a table with values of the last 6 years.There i'm working with set analysis. This works. Now i want to draw a chart (line or bar) with the dimension "YEAR", but in the chart, the selection of the year 2017 should be overriden, like the straight table.

Thank for your help!

Rolf

[sunny_talwar]

May be like this

Sum({<Jahr>}Netto_Nettowert)

[passionate · Accepted solution]

Hi,

You can use Sum({<Year= >}Sales) in your Expression.

This will not consider your year selection.

Please confirm if this is what you wan't.

Cheers,

Pankaj

[ecolomer]

Is this you need?