Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
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

Public
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: http://jsfiddle.net/flexmonster/v3kvwdjb/7/. Here Price for red Color is null and the count is 0.
Please let me know if you have any other questions.
Regards,
Tanya

Please login or Register to Submit Answer