Hi Community,
How to display % of Female Gender (24%) in Singleton
the list return the following data.
Female 24%
Male 76%
Hello mpervez,
When you put the measure value in the singleton the aggregation set on the data item will total it up to make 100%.
Create a new data item with expression like this...
Case [Gender_Data_item]
WHEN 'Female' THEN [Measure Value]
ELSE 0
END
Set the aggregation of this data item to Total and put in the singleton.
-Cognos810