write a condition for total row

[#1]

Hi,

there is direct option for total row but i want to write a condition for that totals row so is it possible.

QlikTech Admin

[#2]

Hi,

    Yes. It can be possible but depends on your condition also. can your explain here which type of condition you want for total?

Thanks,

Ashutosh

[jagan]

  Hi Pankaj,

Try like this

=If(RowNo() = 0, 'Your Expression goes here', Sum(Measure))

RowNo() = 0 -- Belongs to total row

Regards,

Jagan.

[tresB]

If you are there in pivot table, try using dimensionality()  function.