Hi,
I have made up a Pivot table in Sheet2 with the help of Sheet1 data.What I want in Pivot table is the date range "From" & "To" option to get desired date data result in consecutive column D,E and so on.The data in Sheet1 is not an exhaustive list.
Here,I can select in B1 in Pivot only one even if selected all or partially.I have to defined myself as "From" & "To" date range.
Any help in this regard is highly appreciated.
I have one sample file. I have add one helper column to the original data. using formula =D2<=NOW()
Create "Table Range" in original data range.
Refer "Pivot Table" : As per current timing data record changed. (Need to "Refresh All")
For more clarity, refer attach file.
"Filter Area" : "I1" Change as per requirement.
You need to try something this.
Hope this will help you.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Thanx for the response.It is not this that I am expected.
Yes i know that, but you can do somthing like this. (with similar). If you add table range in your original data & update your "Pivot" & re attach file i can try with your required result.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks