11 Replies Latest reply: Apr 3, 2013 4:04 AM by Hein Schultz RSS

    Count number of same lines in chart

    Hein Schultz

      Hi guys.


      I hope someone can help me please. I actually think this should be quite easy, but i cannot find anything on it.


      I have a chart (that will eventually become a pivot table) that has the calculations i require. However, i need to devide my value with the total instances of the same on the chart.


      So in this example, i need Plan z1 to show 2, and the rest 1. I can then use this number to devide as needed.


      If anyone can please guide me in the right direction. Thanx