Filter report output by count greater than one in a report of multilevel pivot

[TD14]

Hi, 

I'd like to filter a report to show results of only count>1 after group by in a report of a multilevel pivot.

I have knowledge of programming as well if need, please suggest how to do it.

See the attached report that I'm trying to filter.

Thanks in advanced,

Tomer

[Uncle Rob]

Unfortunately you can't do any post-aggregation conditioning.

But how would you even express that on a multi-level pivot.  MLPs will have multiple columns AND rows.  Which intersection would you be evaluating the x>1 on?

[Sherlin Thomas]

Hi Robert,

Instead of Multi pivot, will it be possible to get x>1 after group by in a list report.

Thanks & Regards,

Sherlin Thomas

[Uncle Rob]

If there is a way, I don't know it.  The only thing that comes close is on Pie / Bar where you can select the number of series to display.  

[Sherlin Thomas]

Thanks Robert, as for now will work with Bar chart.

Thanks and Regards,

Sherlin Thomas