In Pie representation selected product as one and rest as others....

[#1]

Hi Friends,

My data having one dimension called as product and one Measure called as sales.

I have requirement to display selected product as one segment and reaming product's has to group as other's in pie chart.

  

In the above picture we have used product as filter when i am selecting one product it should display the selected product and rest of the products as others in pie chart.

Please help me in the above issue, Thanks in Advance...:)

Regards,

Venugopal G

[m_woolf]

See the attached qvw

[kkkumar82 · Accepted solution]

Hi,

I have changed the second expression of MIke . Please find attached.

Thanks

Kiran Kumar

[#4]

Hi Mike/Kiran,

Thanks very much for your reply.

How can i show the total percentage of value in pie chart.

Regards,

Venugopal G

[mohan2391]

Hi,

Can you explain the process here, I have personal edition only can't open your QVWs.

[kkkumar82]

Hi Mohan,

Binary load the file attached above and create a pie chart with out any dimensions.

Create two expressions as follows

1. Sum(Sales)

2. Sum({1-$} Sales)

Thanks

Kiran Kumar

[kkkumar82]

Please find attached I have created %s for the above same sample.

Thanks

Kiran Kumar

[#8]

Hi Kiran,

I want to remove one specific product from others let say Product C.

Because i don't want to include the product c in others.

Please help me ASAP.

Regards,

Venugopal G

[kkkumar82]

Hi Venu,

I don't think it is possible.

Best Regards

Kiran