Static dimension

[krish2459]

Hi,

I'm using the funnel chart.

I need to keep Funnel chart dimension satatic at dimension level.

Dimension: Attributes

Expression:  

if(Attributes='TOTAL DEFOA', Count({1}distinct [Commercial DEFOA: ID]),
if(Attributes='SUPPLY CHAIN SECURITY ISSUE', Count({1<[Supply Chain Security Issue]={'Yes'}>} [Supply Chain Security Issue]),
if(Attributes='CORE PSCS', Count({1<[Core PSCS]={'Yes'}>} [Core PSCS]),
if(Attributes='NCR', Count({1<[NCR #]={'Yes'}>} [NCR #])))))

Thanks,

Krish

[krish2459]

HI,

I have tried using the below calculated dimension but still no luck.

=Aggr(Only({1}Attributes),Attributes)

Thanks,

Krish