Expression to include rows from other groups in Pivot

[rfigueroa]

Hi all.

In this sample, on the column No_Alloc I want an expression to COUNT all rows which are

[AllocateMonth]  > [InitMonth]

but also including those records where [InitMonth] is less or equal than the current.

So for example, in the row InitMonth = 201609, No_Alloc should be 7.

Correct report:

Thanks in advance

Roberto

[Anil_Babu_Samineni]

May be try this?

=Count(If(AllocateMonth > InitMonth and InitMonth <= Max(TOTAL AllocateMonth),GrpID))

[rfigueroa]

Thanks but it doesn't work.

I'm expecting in the first 4 rows the values: 5,6,7,7

This is what I get with your expression: