Classifying in a chart

[martinpohl]

Hello,

I have a table with value from (bewvon), value to (bewbis) and class (Bewertung)

bewvon	bewbis	Bewertung
0	80	6
80	90	5
90	95	4
95	97	3
97	99	2
99	99,8	1
99,8	100	1

Now I want to compare the result of a formula with the values from/to to show the class in a pivot chart.

My statement:

= max({<bewbis={">=$(=Sum ({$<LFSTAT_HERKUNFT+={E}>} LFSTAT_ANZEDI)/Sum ({$<LFSTAT_HERKUNFT={E,D,M}>} LFSTAT_ANZBEL)*100)"}>} Bewertung)

unfortunately the result in each row is the compare result of the total (see "Bewertung").

KONZERN	GJ	Monat	Belege	EDI	Bewertung	Wert
ELECTROLUX	2010	JUL	2737	2643	3	97
		AUG	2672	2631	3	98
		SEP	2782	2755	3	99
		Gesamt	8191	8029	3	98
	2011	OKT	3254	3216	3	99
		NOV	3179	3123	3	98
		DEZ	2913	2842	3	98
		JAN	2828	2599	3	92
		FEB	3135	2921	3	93
		MAR	2296	2163	3	94
		Gesamt	17605	16864	3	96
	Gesamt		25796	24893	3	96

to compare the result I show you the result of the formula (see "Wert")

Any ideas?

Regards

[martinpohl]

No ideas?

Regards