Bar chart

[madmax88]

Hi,

I have a data set with Sales, Advisor, Region, Month 

and a 2nd Data set with Region, Target, Month

I want to show the goal over the 12 Months, but only the actual cumulative sum of Sales. E.g. I have the Sales of January and February and I want to show the cumulative sum of the sales. For this I have the rowno function. 

Now I want also to show the Target between January and December. But there it shows me only the target of January and February and not the other months. Any idea?

When I Use another function as a standard set analysis with sum, it works, but then I don't have a cumulative sum..

[Channa]

can you share app or sample screen

[madmax88]

Unfortunately not...
At the moment I use following expression:
rangesum(above(sum({$<Region={'A'}>}Target),0,RowNo()))

But there it shows me for month January the correct amaount and the other months are all on the same level as February

[Channa]

may be there is not sales for Region A for March and after

may be it is showing for current year we are in FEB only

[madmax88]

yes, thats true. There is only Sales for Jan and Feb, but the Target is shown cumulative by month between Jan and Dec.

So it should show all 12 Months with the cumulative target line and 2 bars with the cumulative sales in Jan and Feb. Is this not possible?