SAS Visual Analytics - drop down filter for years, accumulated

[DharmeshTadvi]

Hi i want to filter out data like whenever user select any particular year so less then that year all year's Due Amount's sum should reflect in text box !! any idea how can i do that  ? please help 

Or any other alternative way

[MichelleHomes]

If you are using SAS Visual Analytics 7.4, you can use a Dynamic Text Object to achieve what you are after https://communities.sas.com/t5/SAS-Communities-Library/SAS-Visual-Analytics-trick-Use-a-button-bar-a...

Kind Regards,

Michelle

[FredrikE]

If I understand you correct your report now only show due amout for the selected year (2019 in this case) but you want it to show all years prior to 2019, is that correct?

If so you need to use a parameter assigned to the drop-down list. You also need to remove the drop-down from the prompt area and instead put it on the report area (where the bar chart is located).

Assign the parameter and then create filters for the bar chart and text objects saying (due_date_year < [parameter].

I am on the right track 🙂 ?

//Fredrik

[DharmeshTadvi]

Hi,

As you suggested I did that but my problem not solved yet,

Let me explain you .... I want to show Due_Amount when I select any year <= that year's Total Due Amount should reflect in graph .

Month wise and organization wise you can say cumulative add on. I am sending you data file also if you need.

[FredrikE]

Can you desctribe the wanted outcome in a graph och drawing, maybe easier for me to understand 🙂

Do you want the figures to be accumulated for each month within the selected year?

//Fredrik

[DharmeshTadvi]

ok....wanted outcome is like ...whatever Year I select that year's month should reflect with value of Amount , now value i want is month's value should be cumulative by Organization.

for example : FEB 2015 value is 1987066 then it should be add on in next month in March 2015  = march's value + previous value

now when i select April 2015 its's value should be April value = FEB's value + march's value + april's value 

and it should be dynamic ....based on Organization variable ,,,thank you for helping

[FredrikE]

I think you can do that with an aggregated measure showing YTD.

Right-click on the measure and select "Create-YTD" (or what it is called in english).

//Fredrik