How to display % of Female Gender (24%) in Singleton and not return as 100%

[mpervez]

Hi Community,

How to   display % of Female Gender (24%) in Singleton

the list return the following data.

Female     24%
Male         76%

[cognos810]

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