Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

Average Row

Hi Friends

I have below shown pivot table in my QV document. However Last row(Average Per month) I have added manually in excel format. I want to add that row in the QV Pivot table itself. Kindly help to do so.Screenshot_1.png

6 Replies
agastya
Creator
Creator

share your excel file

upaliwije
Creator II
Creator II
Author

I have attached my excel file

sunny_talwar

You want to keep Sum and add Average row?

rubenmarin

Hi Uplai, PFA to check if this workaround can help.

upaliwije
Creator II
Creator II
Author

Yes Of Course

sunny_talwar

Take a look at the approach from here

Average help | Qlik Community