How To Provide Specific Expression on for specific Dimension Value

[SatyaPaleti]

Hi Folks,

Here there is a requirement I need it

I have 2 dimensions 1. Month and 2. Categories and I have 2 Expressions 1. Sales an 2. Target

Here I have Create Pivot Table . In the below Pivot Table we have metrics like Sales, Target & Percentage (%). But Percentage should get appear only for Dimension Value Others.  Can some one please help how to make % should appear only for Others. For more etail please find attached files for excel an QVW

Thanks an Regards,

Satya

[giovanneb]

Hi, Try this

sum({$<Categories = {'OTHERS'} >} Target)/sum({$<Categories = {'OTHERS'} >} Sales)

[SatyaPaleti]

Thanks for quick responce But below pivot chart is coming