I haven't done it but it is definitely possible using SAS's row-level security functionality:   http://support.sas.com/documentation/cdl/en/birlpug/64774/HTML/default/viewer.htm#n0ayni3o5acnd9n1mwo8tkrytv56.htm   With SSO and SAS each user has an identity in SAS metadata which can be used to applied to restrict data access.    ... View more

Thank you so much for your reply! Sorry new here I just now saw that you replied.    In the first spreadsheet "Before" I don't have the variance as displayed in "After" which definition for variance (highlighted in yellow) for this purpose being:   Fiscal year 2017 (Periods) Diamonds - Fiscal Year 2016 (Periods) Diamonds = how many more/less diamond orders we have for the current period "month" in correlation to the same period last year. Also, Fiscal year 2017 (Periods) Pearls - Fiscal Year (Periods) 2016 Pearls = how many more/less Pearl orders we have for the current period "month" in correlation to the same period last year.   But I only want the variance to display through current period I don't want it to calculate for months that have not occurred yet.  So for example period 6 (November) has not occurred yet so it would be blank (See After example highlighted in yellow).   This is easy for me to do in an excel spreadsheet but I need to build it in Enterprise Guide.  Thank you again for all your assitance! ... View more