• 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.

Dynamically select mulitple pivotitems

Status
Not open for further replies.
T

Trushant

New Member
Hi,

I want to select multiple items in a pivot filter (pivot items) using the value in a specific cell. I have a pivotfield "Services Applicable" having pivotitems ("Imaging", "Cataloguing", "Imaging, Cataloguing", "Imaging Cataloguing, Fly"). I want to select multiple items basis the value in cell H1.
For eg: H1 = Imaging
In the pivotfield("services applicable") = Multiple Items (Imaging","Imaging, Cataloguing", "Imaging Cataloguing, Fly")
(It should not be just Imaging)
 
Status
Not open for further replies.
Back
Top