Conditional Format Pivot Table Lines, Sub Totals and Totals

[dinicholls]

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

[sunny_talwar · Accepted solution]

May be like this:

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

[dinicholls]

Thank you!

Worked a charm!

[sunny_talwar]

Nice

[sandipahire]

How to add Average along with Total