Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
engr_farhanqadr
Contributor

Issue in totaling pivot table

Dear Folks,

I have a pivot table in which I am showing the totals of each row at right. In Total Cost row the total is coming wrong.

I have two dimensions Director and Branch. what could be the possible solution of this issue.

Thanks

Tags (1)
2 Replies
MVP
MVP

Re: Issue in totaling pivot table

Try your expression constructing with additional sum() like:

Sum(Aggr( <ExistingExpression> , Director, Branch))

andrey_krylov
Valued Contributor

Re: Issue in totaling pivot table

Can you share your expression?