Hi Guys!, Long time reader and first time poster!
I have a question about working with lists in sharepoint 2010, I have played around a little but have not found a way to show the data in KPI or view filters as i would like, I have a list that contains information on contracts, There is rows such as start date and end date etc, None of which are calculated, all entered manually, What i am trying to do is display in KPI format Contracts that will expire within 3 Months of Today as a one kind of KPI and contracts that will expire one month from Today as another, I would like this to be viewable outside the list, the biggest issue i have is how do i format that filter? and how then do i output to a kpi, I can do a standard [TODAY]+90 for example as a way of showing items that will expire 90 days after today but that seems to be only showing items that will expire in exacly 90 days and will not display 89 for example, Bear in mind im looking for help to do this using the basic sharepoint GUI, i have no experience with sharepoint designer!
Hope you can help
Thanks in advance