How to count non zero values in measures ??

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