I
Impecunious
Hi,
In a Pivot Table, I'm using a field named "CBU" in my row area, which
has item values of "HP" and "AC". In my column area, I'm using a date
period. The data area has quantity, which I've converted to show % of
row, which naturally gives me the percent breakdown that AC and HP
represent out of the total.
My problem is, in an associated Pivot Chart, I only want to see the
percent of total that HP represents - I don't want to see AC. My
reason for this is that I'd like to see this HP percent of total by
another attribute - a "CHANNEL" attribute with 3 items - in the
chart's data area, which would ideally give me the HP % by each
CHANNEL item. As it stands now, I'm getting six graph lines instead
of 3, because of the AC component.
Is there a way to do this that's quick and "on the fly"? I'm using
this chart for other insights, so I can't spend much time building
this particular view when the time calls for it.
Thanks in advance!
In a Pivot Table, I'm using a field named "CBU" in my row area, which
has item values of "HP" and "AC". In my column area, I'm using a date
period. The data area has quantity, which I've converted to show % of
row, which naturally gives me the percent breakdown that AC and HP
represent out of the total.
My problem is, in an associated Pivot Chart, I only want to see the
percent of total that HP represents - I don't want to see AC. My
reason for this is that I'd like to see this HP percent of total by
another attribute - a "CHANNEL" attribute with 3 items - in the
chart's data area, which would ideally give me the HP % by each
CHANNEL item. As it stands now, I'm getting six graph lines instead
of 3, because of the AC component.
Is there a way to do this that's quick and "on the fly"? I'm using
this chart for other insights, so I can't spend much time building
this particular view when the time calls for it.
Thanks in advance!