11 Replies Latest reply: Oct 24, 2013 3:26 AM by Saurabh Ramya RSS

    One condition and one formual in same expression in Pivot Table

      HI guys,

      My pivot table looks like this

      Screen Shot 2013-10-23 at 11.40.51 PM.png

      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.