Per your suggestion, I created a new dimension Rank(sum(FINANCED_AMT)). However, it displays 'Error in Calculated Dimension'. Also, assuming that this works, how can we display this column as a line chart within the regular table?
Thanks. I think I am getting there. In the mini-chart settings, I do not see a horizontal bar chart option. Also, how would I show it in such a way that the Rank value of 1 shows the longest horizontal bar?