Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jozisvk11
Creator
Creator

Problem with Pivot table

I have table :

   

DivisonFin. MounthRevenues
ABAJan740 123 €
ABAFeb1 013 241 €
ABAMar232 803 €
Jan740 123 €
Feb1 013 241 €
Mar232 803 €

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

DivisonFin. MounthRevenues
ABAJan740 123 €
ABAFeb1 013 241 €
ABAMar232 803 €

Could you help me ? Thank you.

5 Replies
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€')

Capture.PNG

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
jozisvk11
Creator
Creator
Author

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

jozisvk11
Creator
Creator
Author

yes, it is OK

Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)