Get Free Trial

How to count non zero values in measures ??

Himasree Vemuru asked on January 10, 2018

We have option to calculate the count of values but I want to count number of non-zero values exists in column.Please help me to customize this.

1 answer

Tanya Gryshko Tanya Gryshko Flexmonster January 11, 2018

Hello, Himasree,
Thanks for the interest in Flexmonster Pivot!
Our Count function is counting a number of non-zero values. Please have a look at the following sample: Here Price for red Color is null and the count is 0.
Please let me know if you have any other questions.

Please login or Register to Submit Answer