Pivot Table - Show Data for a Particular Value

microwin88x — Thu, 27 Mar 2014 20:11:28 GMT

Hello!

I have a Pivot Table with the following Fields:

And on the other side I have this expression:

=ONLY({<USER_APP={$(vUser)}>} OFFICE)

Where that expression returns me the corresponding Office that is associated to a User

Now my question is the following:

Each Client is associated to a particular Office where he works.

I want to put a filter in the Pivot Table in order to show me only the Clients that belong to the Office obtained in the expression =ONLY...

How can I do this?

Thank you!!!

Re: Pivot Table - Show Data for a Particular Value

Josh_Good — Thu, 27 Mar 2014 23:46:59 GMT

Try

sum( {$<Clients= P({1<Office={$(=chr(39) & ONLY({<USER_APP={$(vUser)}>} OFFICE) & Chr(39)}>} Clients)>} Attentions)

I assumed your base expression was

Sum(Attentions).