How to get relative % while using Pivot charts

[#1]

Hi ,

Can anybody guide me to get "relative %" while using Pivot charts .

We can able to get it if we use striaght table , but unable to achieve the same using Pivot drill down options.

Regards,

Bhushan N

[#2]

You have to create separate expression for that..

1. Count(Problem_ID) - it gives you the count

2. Count(Problem_ID)/Count(Total Problem_ID) - it gives you the relative %. In number tab, you ve to choose Show in % option or use (Count(Problem_ID)/Count(Total Problem_ID))*100 to get the %