Count items in pivot table and show it in the total line

[#1]

Hi, I would like to present a pivot table shows sales Qty (only if it's over a hundred) per designer, product number and sale date.

In the total line I would like to show something else: the number of the cells populated with sales values.

Example attached.

Thanks

[#2]

Hi,

I suggest you to use Dimensionality() function. It lets you to identify where is the total row.

MIlda

[Anonymous]

Hi Meital,

Try this

=count([Sale Date])

as expression.

Regards,

Nandha