Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In my straight table i see the option of having the Total Row in the Top or Bottom of the Chart, but is there a way to include it in the sorting so that I could quickly see which customers are above or below the average line?
i e
Cust A $4
Cust C $3
AVERAGE $2.50
Cust B $2
CustD $1
Do not think that this is possible, but you may colour the customers above or below average.
Peter
Might it be possible to use a Sort on the amount? You do need Average to be a field within the table (a customer). Probably have to do that while loading the table.