10 Replies Latest reply on Dec 5, 2016 12:18 AM by Amit Narkar

# How to show pie which 2 measures

Hello every one ,

I have 2 measure in data source and i made two calculated field for each measure for their percentage calculation,

Now i want to show both measures on pie chart and just below the Value i need to show %age value for which calculated field is created .

• ###### 1. Re: How to show pie which 2 measures

Setup your sheet like this using measure values and measure names

1 of 1 people found this helpful
• ###### 2. Re: How to show pie which 2 measures

Hello Tom,

But with this we can not see both value together in Pie chart only profit /sales is showing in Pie chart.

Regards,

RAV

• ###### 3. Re: How to show pie which 2 measures

Take a look at attached workbook

• ###### 4. Re: How to show pie which 2 measures

Hi Ravinra,

To get both values together like profit/sales , also drop the cal fields  into the label shelf .

Thanks,

Triveni.

• ###### 5. Re: How to show pie which 2 measures

Here how will we show % profit and % Sales  ie profit and % profile together and sale and % sale together

• ###### 6. Re: How to show pie which 2 measures

Hi Amit ,

I cant find attached worksheet .

Mausami

• ###### 7. Re: How to show pie which 2 measures

Hi Triveni ,

That will not work . I have tried

Mausami

• ###### 8. Re: How to show pie which 2 measures

You are looking at the thread through your inbox. Take a look at it directly.

• ###### 9. Re: How to show pie which 2 measures

HI Amit ,

In your workbook it is showing Quantity and sales but i need both of their percentage as well with there actual values

• ###### 10. Re: How to show pie which 2 measures

Calculated %s

sum([Quantity])/sum([Sales]+[Quantity])

sum([Sales])/sum([Sales]+[Quantity])

and Display as Label that's the only sensible way I can think of.