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
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?