Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
MVP & Luminary
MVP & Luminary

Re: Pivot Table _ Total Price

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


talk is cheap, supply exceeds demand
2 Replies
MVP & Luminary
MVP & Luminary

Re: Pivot Table _ Total Price

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


talk is cheap, supply exceeds demand
Highlighted
renjithpl
Valued Contributor

Re: Pivot Table _ Total Price

Use aggr() 

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