Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
dinicholls
Creator II
Creator II

Conditional Format Pivot Table Lines, Sub Totals and Totals

Hi All,

First off, apologies if I don't explain this properly, feeling a bit sqwiffy at the mo, and its getting the better of me!

Here goes.

I have a pivot table that list details of outgoing call made per person / year / month / date. I have added averages, total no calls, time etc. I now need to add a 'Target' to the number of call made by each person, each day. I though this would be easy, but whenever I add the target of 40, to either a file, inline or just as an expression, it shows it as 40 in each day, but doesn't add it for each week, month, year etc.

Have added a jpeg of what I mean!

What am I doing wrong? Its driving me potty!

Thanks

Di

1 Solution

Accepted Solutions
sunny_talwar

May be like this:

Sum(Aggr(Sum([Lower Target]), Agent, MonthYear, WeekYear, [Contact Start]))

View solution in original post

4 Replies
sunny_talwar

May be like this:

Sum(Aggr(Sum([Lower Target]), Agent, MonthYear, WeekYear, [Contact Start]))

dinicholls
Creator II
Creator II
Author

Thank you!

Worked a charm!

sunny_talwar

Nice

sandipahire
Contributor
Contributor

How to add Average along with Total TotalAvg.png