4 Replies Latest reply: Jul 15, 2010 12:43 PM by Miguel Angel Baeyens de Arce RSS

    Help with displaying results which are less than 9999

    Chris Hopkins

      Hi,

      I have a dimension in a PIVOT TABLE called 'EAN', EAN's are barcodes which range from 1 - 9999999999999. I only want numbers up to 9999 to be displayed within the EAN dimension, all numbers above 9999 i want to be excluded from the results.

      Can someone tell me how to achieve this please?

       

      Thanks