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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot Table _ Total Price

Hi my friendsPivot.jpg.

i want to use this total price i another expression fo each group.

what can i do?

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Use aggr( sum(Budget), Costnumber) to get the totals of sum(Budget) per Costnumber


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Use aggr( sum(Budget), Costnumber) to get the totals of sum(Budget) per Costnumber


talk is cheap, supply exceeds demand
renjithpl
Specialist
Specialist

Use aggr() 

=sum(aggr(max(Value),CustNum))