Pie chart with 4 measures

[cognos05]

Hi ,

I have a query with four calculated data items an when put ona list shows these values

DiscountA  DiscountB    PromotionalSavings  Rebate Amount

26500      242000         0                            11350

User is requesting this to show on a latest pie chart by percentage value .


Pie chart has only 2 inputs segments and size . so now my 4 measues are my categories with value on it.

Has anyone had similar use case and how did you achieve the similar result .

did you use an old pie chart or had a pass thriugh sql in required format.

Thanks,

[BigChris]

It's not very clear what it is that you're trying to show in the pie chart. What do you want the percentage to be? Rebate Amount / Discount A ?

You might want to reconsider if the pie chart is the best way to represent your data.

[cognos05]

I am showing four categories in pie chart which is

discount A
discount b
promotional savings
Rebate Amount


so it divdes the amount in each category by total amount of 4 columns.

[BigChris]

Ahhh...ok, that makes slightly more sense. In that case, based on your original figures, you presumably want something along the lines of
Category       % of Total
Discount A        9.5%
Discount B       86.5%
Promotional        0%
Rebate               4%

[cognos05]

Yes exactly ,like the results you have.

I have the four data items with measures

DiscountA  DiscountB    PromotionalSavings  Rebate Amount

26500      242000         0                            11350

And I need in pie like

Category       % of Total
Discount A        9.5%
Discount B       86.5%
Promotional        0%
Rebate               4%

Now i wanted to know how to get them in pie , becasue pie accepts one measure and category

Thanks,