Using Thresholds in SAS VA

[don21]

Hi,

I have the below requirement, I need to create dynamic averages example for rolling 3 months and compare with the selected month.

Example: this month is Nov'19and sales total for Nov'19 is 20 and the rolling 3 month avg (last 3 month avg) is 25.

I have created an aggregated measure for rolling 3 months avg successfully. But, I need to set the threshold in graph not in table.

For this I have taken Dual access line chart. One measure I have given Sales total and other I have given rolling 3 month Avg.

Data I have:

Prod_A_Sales  Prod_B_Sales   Month

5                            6                     Jan'19

10                         15                    Feb'19

20                         24                    Mar'19

What I need to showcase is a line chart or bar chart where bars will be product for any month. and a base ine or threshold line with Avg value.

I have used a bar line chart for this and tagged avg variable to the line. I am unable to stabilize the line straight with single value. please help how I can select _FORALL_ in the aggregated measure so that the threshold line will only show one average. like If I select Nov'19 from date filter. The product (bars) show nov totals and line will show (Aug, sep and oct avg) with st line.