=if(Sold=1, 'Sold'&Repeat(chr(160),15)&aggr(num(count({<Sold={1}>}Sold),'###,##0'),Sold), 'Yet to sell'&Repeat(chr(160),15)&aggr(num(count({<Sold={0}>}Sold),'###,##0'),Sold))
//Sold field has 0's and 1's as data
Expected outcome:
Sold 601,102
Yet to sell 209,125
Actual outcome:
Sold 601,102
Yet to sell 209,125
Yet to sell
Why I am getting an extra line (3rd row) in my filter pane that displays "yet to sell"? I dont want that 3rd row.
If you think I am doing the entire thing wrong, please advice. Any guidance will be helpful.
