Hello all,
I have a Calculated field "bucket_tnrx " like this
IF SUM([T Pts])>=1 and SUM([Transaction Points])<=500 then "1-501 Tnx "
elseif SUM([T Pts])>=501 and SUM([Transaction Points])<=1000 then "501-1000 Trnx "
elseif SUM([T Pts])>=1001 and SUM([Transaction Points])<=5000 then "1001-5000 Trnx "
else ">5k Pts"
end
When i drag this calculated field to color i get like this
How do i change my calculated field so that i get different lines(not in one line)
Thanks.
Try swapping the row and column fields in your worksheet. Then drag the calculated field to color.