Show N records in pivot table

[#1]

Hello,

I would like to know how to show for example 3 records in a table based on a value selected in a filter.

For example if i select a month/year 01/2014 i would like to display in pivot table records for 01/2014, 02/2014 and 03/2014.

Thank you very much for your answer,

Regards,

P.L.

[Anonymous]

Would you be able to attache some sample data?

Thanks,

[#3]

Hello Sir,

Thank you for your quick answer.

In attach to my first post, a brief example of what i want. (example with month April)

Thank you,

Regards

[Anonymous · Accepted solution]

Check the attached file. see if it helps.

[ramoncova06]

they are couple of options to achieve this

check this thread Customers Having Top 4 Values

thanks

[#6]

Hi,

I calculated next_month in script and used in the expression:

sum({<month=, number={">=$(=Only(number))<=$(=Only(next_number))"}>} Value)

[#7]

Hello Amarbogam,

Thanks again for your prompt reply.

This perfectly meets my need.

Thanks a lot,

Regrads

[#8]

Hello Ersen,

This also works great for me...

Thanks a lot for your help,

Regards,