Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
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"

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful