I am trying to use the columnno() function in the Show column if condition for my conversion rate measure within my pivot table. I am trying to show the quote counts for converted and unconverted quotes, and then show the conversion rate only for the totals column. The columnno() function is working properly. Why do I get "The calculation condition is not fulfilled"?
In the pic attached, you can actually see that the Columnno() returns zero in a pivot table for Totals column. When using this calculation for the Show column if condition, I expected the pivot table to show three columns for #Quotes: Total, 0 , 1 (0 and 1 are converted indicators), then for Conversion rate, I only wanted to show one column: Total (not showing 0 and 1 column).