There are cultural affectors about that kind of problem, and also technical ones.
For example, in France, if you put-in-your-face a chart with more than 12 quarters, ... plop ! will say the (common) brain ... ... elsewhere, if the readers are tax accountants, under 40 quarters, your job will become suspicious !! If you have begun a deal with a new media last year, you'll be sorry if this one, making few results at the end of the year, is not exclusively quantified in the chart, and only grouped with "other ones" quarter, because of the poor CA ! You must need to identify, then to classify, and alter group the data. Better use is to create a second column, indicating a trigger level relating opportunity of related data. You'll be then able to excerpt 'politically validated' data, and show them in their relativity, then process rest. If such a criteria is not given, i use to make discrimination with MIN(AVG, 'median value'), if elected i then compare to largest value. If < 1/5, i aggregate. If not, i maintain the value as individualy 'printable'. Gérard. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/8c4350f45e084457ba8c2ea764396...@muriellepc ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
