Hi Guys,

I have a pivot table and I want to get at over 5k on a per month basis.

if one month is only visible in the pivot table, figures shows only the over 5k but when i added new month, the previous month will now show the less than 5k that i created a criteria. is there a way to do this in pivot table.

please advise.

Thanks.