Hi,
Just wondering if somebody could help me with this. I have approx 5,400 lines of employee expense data (for the past 12 months) from which I have created a pivot chart. I am really only interested in the following columns from the base data:
Contract Amount
X0 $1,200
X0
X1
X2
X3
etc
L45
L45
L50
L54
L55
etc
where X is overhead and L is project-related. I would like to create 2 histograms: one for the Top 10 overhead contracts (by sum of amount) and the other for Top 10 project contracts (by sum of amount). The problem is you don't seem to be able to have both a label filter (ie does not begin with X) and a value filter (top whatever). Am I missing something or is this just a limitation of the pivot chart?
I realise I can recut the base data but I would rather avoid doing this. Thanks in advance.
Bookmarks