Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a line chart with year-week and sales_area as dimensions and net sales as expression. For net sales I have to sum 3 separate fields in the table say sale_1, sale_2 and sale_3.
So my expression is something like
AGGR((SUM(sales_1) + SUM(sales_2) + SUM(sale_3)),sales_area,year-week)
Not all sales_area may have made a sale in any particular week.
How do I get the chart for say last 4 or 5 weeks only? I tried using dimension limits for year-week (largest, smallest, first) but I am not getting correct results as sometimes the weeks are not continuous, sometimes some sales areas are not displayed etc.
thanks for helping.
Manoj
Hi,
You could modify your chart some thing like :
if(week(today())-Week(field)>4,exp)
If possible upload sample.
Kiru
PFA
Hi,
Please have a look at the attached file and hopes it help!
Kiru
Hi Massimo,
Somehow SUM({$....} sales1 + sales2) doesn't work for me but SUM({$...} sales1) + SUM({$...} sales2) does.
I noticed the same thing in my another dataset as well.
thanks,
Manoj