Logic in Pivot Table

[aveeeeeee7en]

Hi Community

See the Attachment

Regards

Aviral Nag

[adiarnon]

HI,

I didn't get why in your dimension there is maxstate?!

why don't you change it to state?

[tresesco]

Not very clear about your requirement. Please explain expected output for at least for two scenarios, like: with one or two particular selection(s) and one wihout any selection. If possible explain the logic too.

[aveeeeeee7en]

Sir

I  have one Main Table which has all Closed Tickets.

TicketID,

Location,

Name,

Month,

Year,

Key

From this Table I am calculating Repeat Calls by doing Left Join on it as done in Attached Qvw.

What I want :

To show Count of Key along with count of Distinct TicketId    and show both of them Repeat Calls Location wise.

Scenario1:  When click on MaxMonthName - Feb 2014 the Count of Repeat Calls Filter out and show India - 1 and Japan - 1

whereas data from Main Table - Count of Closed Tickets is:

India - 6 Japan - 3   when click on Monthname