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
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...
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 🙂 ?
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.
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
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.