Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I want to create a Bar chart with 2 Bars, 1 shows me a distinct number of articles sold in a specific month (Jan - Dec). Now i want a second bar that shows the number of articles sold in e.g. Dec and Jan, which would be placed on Jan. On Feb i want a bar that shows Intersection of articles of Jan and Feb and so on!
I hope this explanation gives a good view of what i want.
Thanks in advance!
Regards
Chris
Have you checked the qvf attached above?
Yes that would work.
I thought of a way to do this only via set Analysis, but i think this won't work because we got no access on the dimension through set Analysis.
Thank you for this!
Regards
Chris
If you want in front -end you could try expression like:
Count(If(SubStringCount(Aggr( NODISTINCT Above(Concat(Product,';')), Month), Product)>0, Product))
PFA
This looked like correct in first look, then i added a few more data rows and on 3 i got a wrong value
PFA
Regards
Chris
You used wrong expression. Just copy and paste the expression from above.
Yeah nice! now it works!!!
Thank you very much!