help needed

[antonybi]

Hi Folks,

I have dummy data to create Gander diversity

but am not getting what exactly am looking for !!!

I want to see my out put as per my below snap shot

Can someone help me out from this??

PFB for for your reference!!!

[techvarun]

Hi,

Check the attached.

[antonybi]

Yes i have tried the same.

But

In snap shot, There are only 2 legends(Male and Female).

also have dimensions count by Gander and % by Gander

which is not showing  .

Pls suggest!!

[devarasu07]

Hi,

Try to use Valuelist method,

Dimension:

=Valuelist('Female','Male')

Measure:

Count by Gendar

If(ValueList('Female', 'Male')='Female',Count({$<gendar = {'F'}>}id),

If(ValueList('Female', 'Male')='Male',Count({$<gendar = {'M'}>}id)))

% by Gendar

If(ValueList('Female', 'Male')='Female',Count({$<gendar = {'F'}>}id)/Count(TOTAL id),

If(ValueList('Female', 'Male')='Male',Count({$<gendar = {'M'}>}id)/Count(TOTAL id)))

[antonybi]

Almost closed but my dimensions are Count by Gander and % by Gander

and also have legends are Male and Female.

Can you please kindly look at??

[tresesco · Accepted solution]

Like this?

[rahulpawarb]

Please refer attached sample application.

Hope this will help.

Regards!

Rahul Pawar