I made a calculated field with if( some column <5, "NB", "B") and would like to see aggregated results. Something like NB - 100 units/ B-50 units or NB $1000/ B $500 but the total doesn't show and I can't do pivot with the calculated field. Is this something that requires lookerML?
I don't have access to use lookerml yet and wonder if I play with ML and make a dimension, does it apply to all the other reports too??
Thank you so much in advance for any advice!!