One condition and one formual in same expression in Pivot Table

[#1]

HI guys,

My pivot table looks like this

What I need is  this:

1. I need to hide GroupItem and GroupItemEnd Row

2. I need to make sure that Memo column should not show any value for "Total" Row.

I would like to use RowNo() instead of dimensionality() because dimensions may change for my report.

Regards,

Saurabh

[#2]

Thanks, It works

[#3]

Thanks, it works too.

I made Sushil's answer correct because i got his reply before.