I have a List Table Object where I want to perform certain calculations in certain columns based on a Date Filter object I present to the customer. But I also want to present in that same List Table Object certain calculations that ignore the selections made by the user and always perform a static calculation. Let me explain.
Say I have this table
Employee Name Dept Hours Worked Hours Worked(Year to Date)
Bob 001 120.50 ??
Nancy 007 100.60 ??
Pete 105 200.00 ??
Juan 75 210.85 ??
I am able to calculate the hours worked based on a user-selected date filter with no problem. What i want to do is right next to Hours Worked, where the ?? symbols are: I want to display the total hours worked since the beginning of the current fiscal year, no matter what date range the customer selects.
Is this possible in VA using one data source and one list table object?
Has anyone done anything like this in VA?
Secure your spot at the must-attend AI and analytics event of 2024: SAS Innovate 2024! Get ready for a jam-packed agenda featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.
Register by March 1 to snag the Early Bird rate of just $695! Don't miss out on this exclusive offer.
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.