Count Function in Pivot Table

[#1]

Hi all,

I have posted this problem earlier (Sum of Rows on Count expression in Pivot Table , but this solution takes too much performance and the calculations are timing out for me when filteres are unselected.

Has anyone ever experienced this and have created a different work around ?

Best,

Kevin

[martynlloyd]

Hi Kevin,

Generally, I find it more efficient to to solve these issues in the script at the Load stage. I keep my charts and expressions as simple as possible.

Regards,

Martyn.