Last 5 rows in Pivot Table

[mhmmd_srf]

Hi All,

I have a pivot table which is showing value by Quarter.

I want to show last 5 quarter.

My Expression is like below for dimension:

=If(CstFiscalYearQuarterConcat>= Max( TOTAL CstFiscalYearQuarterConcat,5), CstFiscalYearQuarterConcat).

It is showing perfect.

Now user want see Quarter as Year-Quarter. And it would be :

CstFiscalYear & '-' & CstFiscalQuarterNum

These concated field is not working in the above syntax. I feel this is not a number, that might be the reason.

Could anyone please help me out.

Thanks,

Sarif

[afsarshaikh]

Hope this works:

Concat(distinct CstFiscalYear ,'-',CstFiscalQuarterNum)

[Kushal_Chawda · Accepted solution]

create the numeric quarter value using DUAL function like below in script

=dual(CstFiscalYear & '-' & CstFiscalQuarterNum,CstFiscalYear&CstFiscalQuarterNum) as CstFiscalYearQuarterConcat

Now you can use condition

=If(CstFiscalYearQuarterConcat>= Max( TOTAL CstFiscalYearQuarterConcat,5), CstFiscalYearQuarterConcat)

or

=If(CstFiscalYearQuarterConcat<= Max( TOTAL CstFiscalYearQuarterConcat,5), CstFiscalYearQuarterConcat).