For one dimension, show the first row only

[#1]

In a Pivot Table, I have a calculated dimension 'Client Name'. I have another dimension Year Month.

For each Client Name, I would like to filter on the first row for Year Month. In other words, I would like to keep only the first date (Year-Month) for each Client Name.

For example, in the table above, I would to keep 2011-07 for the first client name, 2011-10 for the second client name, 2011-12 for the third, 2012-06 for the fourth etc... All other rows should be filtered out, namely 2013-06 for the second client name, etc...

Which approach would you suggest?

Thanks in advance

[#2]

I don't think this is posible in a pivot table without making the a precalculation in the script which returns only 1 value.

Other option might  be changing this to a straight table. Here you have 2 options of dimension limiting:

1. Use Dimension limits (3rd tap in object properties)
2. Use Max Value = 1 in presentation tab and sort on latest yearmonth

[#3]

Thanks a lot, I am trying the solution with the straight table.

1. For which dimension should I set limits? I struggle to find how to use the limits.

2. I set MaxValue to 1, and this basically shrink my table to the first row for account.... I would like to keep ALL Account, but display only one row for transaction per account.

Thanks in advance.

[#4]

Ah I see. I think its posible with the first option.

Could you upload the qvw?

[#5]

Thanks for your reply.

Actually, I cannot. could you elaborate on your idea?