Here is my situation,

I have following measure

QTY_YES, QTY_NO, QTY_UNK and


Dimension : Chargable (All),Y , N or U



IF Chargable

I want to know

(All) (QTY_YES+QTY_NO+QTY_UNK)/1000000

Y QTY_YES/1000000
N QTY_NO/1000000
U QTY_UNK/1000000



Can you help me how to create calculated measure for above scenario ?


Thanks in advance

Kalyan

See my reply to your earlier post.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <37E8E283-5723-4CE7-A284-EDAA26F94B18 (AT) microsoft (DOT) com>,
Kalyan (AT) discussions (DOT) microsoft.com says...