Hello All,
I am a new user and just signed in today. I need your help to solve the attached sheet.
Summary :
## It should contain the dates only from the Data Sheet |
## The To Date can be the From Date but definitely it should after From Date. I should get the filter |
## If the To Date is earlier from the " From Date", the field should be blank. Technically, I should get only the dates avaiable after the To Date once I filter. The "To Date" should be after From Date only |
Problem to Solve Set 2 |
** Once I select the data, the total should be done as per the date selection and it should give the total of the Field "Med_Type" only if available |
** Entire Data set should be visible giving me the date details on the top, Med_Type in row and the total in the column as per the date selection. Example Shown in Column "O". I need the "Count " and not the sum
Thank you, Shiv |
No file was attached. Please try again and don't forget to press "Start upload" and wait for it to finish before you submit your reply.
Hello Riny,
Thank you.
I have attached the sheet.
Regards,
Shiv
Thanks for the files, but I'm not sure that I understand what you want. Perhaps a pivot table with a time-line that allows you to set the start and end dates. I've added such a table to your workbook. If that's not what you want, please clarify.
Thank you Riny,
Below are the details:
Problem to Solve Set 1
## It should contain the dates only from the Data Sheet
## The To Date can be the From Date but definitely it should after From Date. I should get the filter
## If the To Date is earlier from the " From Date", the field should be blank. Technically, I should get only the dates available after the To Date once I filter. The "To Date" should be after From Date only
Problem to Solve Set 2
** Once I select the data, the total should be done as per the date selection and it should give the total of the Field "Med_Type" only if available
** Entire Data set should be visible giving me the date details on the top, Med_Type in row and the total in the column as per the date selection. Example Shown in Column "O". I need the "Count " and not the sum
Thank you,
Shiv
No need to repeat your initial question. I just don't understand what's needed. Did you look at the file I uploaded? Does a pivot table do what you want? If not, clarify your requirements.