Adding rows pivot table

[#1]

Post translated with Google Translate.

Please only post in English, unless you are posting in a language specific section.

---

Hello everyone,

                     I have the following problem. When I want to show the totalized a column in a pivot table, the total is wrong

the expression used is: = Count ({$ <Year = { '$ (vAñoAnterior)'}, Month =, Dia =>} DISTINCT ProductID)

Attached a picture of the pivot table.

Regards,

[philipp_kunz]

Hi try this,

= Count(aggr(Count ({$ <Year = { '$ (vAñoAnterior)'}, Month =, Dia =>} DISTINCT ProductID),Month,Dia))

Regards