Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Get fixed numbers in one column in a pivot table

Hello!

I need help to get fixed numbers in one column in a pivot table. It´s a simple Result report and in one column I would like to always show the full year budget numbers regardless of month selection. I only succeeded in showing each month budget numbers based on selection.

Thanks in advance!

Regards!

Mårten 

1 Solution

Accepted Solutions
Not applicable
Author

Try this Sum({<Month=>}Sales)

View solution in original post

2 Replies
Not applicable
Author

Try this Sum({<Month=>}Sales)

Not applicable
Author

Hello Vidhya! 

So easy, thank you, now it works.

Best regards

Mårten