• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Pivot Report Filter Value Min-Max

S

Sinu

New Member
i have a excel pivot having a few columns and also having Date field as report filter.

Question: Is it possible that i can get a min and max of the dates selected in the report filter outside of that pivot? Means, I will have 2 cells outside of this pivot area having the min and max values of the dates selected from the pivot report filter.
 
Hi Sinu,

Do you mean...dates that you want to select are a part of pivot report filter...??
And can you also share a sample file for the members around to help you

Regards
Asheesh
 
Yes. Dates are a part of pivot report filter. Please find attached the sample file.
I want to have values in cells L3 and L4 based on the values selected in I2(pivot report filter).
 

Attachments

  • Min-Max.xlsx
    12.3 KB · Views: 5
@Sinu

I doubt it is possible without macros...however, if you are looking for an alternate solution with formulas...see the attached...

Regards
Asheesh
 

Attachments

  • Min-Max.xlsx
    14.7 KB · Views: 4
Asheesh said:
@Sinu

I doubt it is possible without macros...however, if you are looking for an alternate solution with formulas...see the attached...

Regards
Asheesh
Click to expand...
Asheesh said:
@Sinu

I doubt it is possible without macros...however, if you are looking for an alternate solution with formulas...see the attached...

Regards
Asheesh
Click to expand...


Thank you @Asheesh for the reply. But what i want is min and max values. and this will come from report filter of that pivot. Use of macros are also fine
 
Guess..I misunderstood the question...give me a while I shall get back..heading to a meeting..
 
No formulas or macros necessary. This can be accomplished with a 2nd PivotTable combined with a Slicer on the Date field to keep the two pivots in sync.

Just hide the slicer somewhere out of sight. Or leave it in sight, and let users change the dates by using the Slicer...might be more convenient for them.

By the way, I suggest you change your source data to an Excel table, so that whenever you refresh the Pivot, any new data will show up in it without you having to repoint it.

See attached.
 

Attachments

  • Min-Max.xlsx
    16.9 KB · Views: 5
Hi Jeff, Nice..checked it on my friends system..I better upgrade to 2010 now.. :)

Regards
Asheesh
 
You must log in or register to reply here.
Back
Top