Pivot Table - Show Data for a Particular Value

[microwin88x]

Hello!

I have a Pivot Table with the following Fields:

• Client             (Dimension)
• Category       (Dimension)
• Subcategory  (Dimension)
• #Attentions   (Expression)

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!!!

[Josh_Good]

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