Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi, Try this
sum({$<Categories = {'OTHERS'} >} Target)/sum({$<Categories = {'OTHERS'} >} Sales)
Thanks for quick responce But below pivot chart is coming