2 Replies Latest reply on Oct 24, 2012 6:40 AM by Amer Ghanem

    How to add a label on aggregate measure

    Amer Ghanem

      Hello In the attached workbook I have a measure that classifies my account into positive, negative and zero based on the difference between the 2011 and 2012 sales. In my data, each row has the account name, month, year, and amount of sales. When I create a bar chart to show how many positive, negative, and zero accounts I have, I can't find a way to add the total number of accounts for each bar on top of the bar. sorry if my description is not clear but in the attached workbook, in sheet 2, for the positive, I would like to have one label with a value of "2" rather than two labels; one for each account.

       

      Thanks for your help