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.
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