Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Newbie777
Partner - Creator III
Partner - Creator III

Rangesum of column (Month) and row (Year) in a pivot table

Hello,

I'd like to write a rangesum formula in order to sum up both column and rows in the pivot table like below, which is only currently summing up columns.  

Newbie7_0-1633134626798.png

I'd appreciate it if you could let me know how I can modify the measure expression below (especially the yellow highlighted syntax) in order to achieve the cumulative sum of year and month.  

Newbie7_2-1633134776721.png

 

Thank you & best regards,

 

0 Replies