How to count non zero values in measures ??

posted on January 10th, 2018

Answered

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

How to count non zero values in measures ??

1 answer

Please login or Register to Submit Answer