Problem with Pivot table

[jozisvk11]

I have table :

Divison	Fin. Mounth	Revenues
ABA	Jan	740 123 €
ABA	Feb	1 013 241 €
ABA	Mar	232 803 €
	Jan	740 123 €
	Feb	1 013 241 €
	Mar	232 803 €

And I don´t know, why show me sum of rows. I need only first 3 rows.

Divison	Fin. Mounth	Revenues
ABA	Jan	740 123 €
ABA	Feb	1 013 241 €
ABA	Mar	232 803 €

Could you help me ? Thank you.

[sunny_talwar]

Would you be able to share a screenshot of what you are seeing?

[Anil_Babu_Samineni]

May be use this in pivot expression

Num(Sum({<Divison -= {'$(=If(Len(Division)>0))'}>}Revenues),'#,##0.00€')

[jozisvk11]

It is OK: I have problem in my Set analyse.

[jozisvk11]

yes, it is OK

[Anil_Babu_Samineni]

If you solve your issue, You may close this thread by flag "Correct Answer"