Count number of same lines in chart

[hschultz]

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

[Anonymous]

This should help you:

count(total <Plan> Plan)

[kaushiknsolanki]

Hi,

     Try this expression.

     count(total <Region,Plan>Plan)

Regards,

Kaushik Solanki

[hschultz]

Hi guys

Thanx for the feedback. Both work on the Chart, but loses the sum if on a pivot table and not fully expanded.

Any tips on that plz?

[sushil353]

Hi,

please find attached.

HTh

Sushil

[kaushiknsolanki]

Hi,

     Try this.

     sum(aggr(count(total <Region,Plan>Plan),Region,Customer,Plan))

Regards,

Kaushik Solanki

[hschultz]

Thanx for the feedback, but that is not what i am looking for.

What if there were 3 or more instances? and also it should change according to selections.

[hschultz]

That is VERY close to what i am looking for!!

The last issue now is that when i do put it in my Pivot table, it doesn't add the values correctly on my partial sums.

[kaushiknsolanki]

Hi,

     Give an example from your sample data, which sum is not matching? what it is showing and what it should be?

Regards,

Kaushik Solanki

[hschultz]

Please see attached